if then statements

  • Thread starter Thread starter doug
  • Start date Start date
D

doug

I am doing a math project due tomorrow and I have data from rolling two dice
fifty times. I have a left die and right die column. Trying to use
"if-then" statements to count different outcomes (i.e., product is over 20,
sum is 5, left die is odd, both dice are equal, etc) Any ideas how I can make
this work?
 
I am doing a math project due tomorrow and I have data from rolling
two dice fifty times. I have a left die and right die column. Trying to use
"if-then" statements to count different outcomes (i.e., product is over 20,
sum is 5, left die is odd, both dice are equal, etc) Any ideas how I can
make this work?
Click to expand...

Are you referring to the VBA IF statement or the Excel IF() function?

Assuming the latter, if your assignment requires that you use IF() for
the solution, array formulas are one way to do it. After typing the
formula, commit by pressing ctrl+shift+Enter instead of just Enter.
If you forget, select the cell, press F2, then press ctrl+shift
+Enter. For example:

=sum(if(L1:L50*R1:R50>20, 1, 0))

Remember to press ctrl+shift+Enter.

Alternatively, you can avoid array formulas with the following:

=sumproduct(--(L1:L50*R1:R50>20))

Remember to press just Enter.
 
Back
Top