VBA CODE ONLY Write a sub with an IF statement that displays in column H a 1 if the player has more fouls than the avera
Posted: Sun Jul 03, 2022 12:00 pm
VBA CODE ONLY
Write a sub with an IF statement that displays in column H a 1if the player has more fouls than the average, otherwise it shouldcontain a 0. The header should say “Fouls (Code)”. Use the attachedExcel sheet.
Note: There will be a lot of repetition.As a check, column H should show the same answers as column G(Column G Should have the IF formula written in each cells notusing VBA.)
Write a sub with an IF statement that displays in column H a 1if the player has more fouls than the average, otherwise it shouldcontain a 0. The header should say “Fouls (Code)”. Use the attachedExcel sheet.
Note: There will be a lot of repetition.As a check, column H should show the same answers as column G(Column G Should have the IF formula written in each cells notusing VBA.)