Use the following image and show whole procedure of writing formulas Using IF statements, fill in the number of electoral votes for each candidate based on the number of popular votes received: If Clinton's popular vote in a state is higher, she receives ALL electoral votes for that state. Similarly for Trump. Write formulas to calculate the Difference as the absolute value of the difference in popular votes for each state Write formulas to calculate the Alternate Difference without an absolute value. Use IF statements to fill in either Clinton or Trump as the Winner of each state. Use proper formulas to find the summary information in cells B4:C8 Using VLOOKUP statements, fill in the number of electoral votes for a given state in G3 (for example, NEW YORK) and the winner of that state.
Use the following image and show whole procedure of writing formulas
-
Using IF statements, fill in the number of electoral votes for each candidate based on the number of popular votes received: If Clinton's popular vote in a state is higher, she receives ALL electoral votes for that state. Similarly for Trump.
-
-
Write formulas to calculate the Difference as the absolute value of the difference in popular votes for each state
-
Write formulas to calculate the Alternate Difference without an absolute value.
-
Use IF statements to fill in either Clinton or Trump as the Winner of each state.
-
Use proper formulas to find the summary information in cells B4:C8
-
Using VLOOKUP statements, fill in the number of electoral votes for a given state in G3 (for example, NEW YORK) and the winner of that state.
-
-


Step by step
Solved in 4 steps with 3 images









