| 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 |
| 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) | |||
Threaded Mode
