Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then statements
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then statements
On Nov 25, 11:20 am, doug wrote:
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? 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:R5020, 1, 0)) Remember to press ctrl+shift+Enter. Alternatively, you can avoid array formulas with the following: =sumproduct(--(L1:L50*R1:R5020)) Remember to press just Enter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statements | Excel Worksheet Functions | |||
If And statements -- HELP! | Excel Worksheet Functions | |||
If then statements | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
if statements | Excel Discussion (Misc queries) |