Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedded OR, AND statements in an IF structure
I need to write a function that goes as follows:
IF A or B C, Then A1 = 500, Else IF D and E and F 200, the A1= 200, Else A1 = 100. Any suggestions? Also - Is there a function that returns the value of e? -- Thanks, WW |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedded OR, AND statements in an IF structure
For your first question, you could use ...
=IF(OR(A1C1,B1C1),500,IF(AND(D1200,E1200,F120 0),200,100)) For your second question... what do you mean "value of e"? You mean value of E1?.... =E1 -- Zack Barresse Microsoft MVP (Excel) "W Wolfe" wrote in message ... I need to write a function that goes as follows: IF A or B C, Then A1 = 500, Else IF D and E and F 200, the A1= 200, Else A1 = 100. Any suggestions? Also - Is there a function that returns the value of e? -- Thanks, WW |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedded OR, AND statements in an IF structure
Also - Is there a function that returns the value of e? -- Thanks, WW =Mass * (Speed_of_Light)^2? Course, that's only a theory. And in Excel you'd have to define those names first. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedded OR, AND statements in an IF structure
Further to Zack's reply, you can use:
=EXP(1) to return: 2.71828182845905 an approximation for e. Hope this helps. Pete On Apr 21, 9:03*pm, W Wolfe wrote: I need to write a function that goes as follows: IF A or B C, Then A1 = 500, Else IF D and E and F 200, the A1= 200, Else A1 = 100. *Any suggestions? Also - Is there a function that returns the value of e? -- Thanks, WW |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedded OR, AND statements in an IF structure
For your second question...
=EXP(1) If you need it raised to a power other than 1, just put that value in the parentheses. Rick "W Wolfe" wrote in message ... I need to write a function that goes as follows: IF A or B C, Then A1 = 500, Else IF D and E and F 200, the A1= 200, Else A1 = 100. Any suggestions? Also - Is there a function that returns the value of e? -- Thanks, WW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
avoid embedded if statements | Excel Worksheet Functions | |||
Do I need to use VBA for the following control structure? | Excel Discussion (Misc queries) | |||
Help with formula structure | Excel Discussion (Misc queries) | |||
reducing the number of times an IF statement needs to be calculated in embedded IF statements | Excel Discussion (Misc queries) | |||
Need loop structure to get round limited IF statements | Excel Discussion (Misc queries) |