| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement with multiple scenarios.
I am struggling with an IF statement...here's my situation:
I need the default value of a cell (C64) to be 8 as long as cells F24 and F25 contain text "n". If F24 text is "y" (F25 will remain "n"), then I need the value of C64 to be (8-I24). If the F25 text is "y" (F24 will remain "n"), then the value of C64 must be (8+I25). Is this possible to do within one cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF statement with multiple scenarios.
One way:
C64: =8 - I24*(F24="y") + I25*(F25="y") In article , AMS wrote: I am struggling with an IF statement...here's my situation: I need the default value of a cell (C64) to be 8 as long as cells F24 and F25 contain text "n". If F24 text is "y" (F25 will remain "n"), then I need the value of C64 to be (8-I24). If the F25 text is "y" (F24 will remain "n"), then the value of C64 must be (8+I25). Is this possible to do within one cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF statement with multiple scenarios.
Perfect. Thank you.
"JE McGimpsey" wrote: One way: C64: =8 - I24*(F24="y") + I25*(F25="y") In article , AMS wrote: I am struggling with an IF statement...here's my situation: I need the default value of a cell (C64) to be 8 as long as cells F24 and F25 contain text "n". If F24 text is "y" (F25 will remain "n"), then I need the value of C64 to be (8-I24). If the F25 text is "y" (F24 will remain "n"), then the value of C64 must be (8+I25). Is this possible to do within one cell? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF statement with multiple scenarios.
=if(f24="n",if(f25="n",8,8+I25),if(f5="n",8-I24,"neither f24 nor f25 = n"))
You did not say what to do if bothe are not "n" "AMS" wrote: I am struggling with an IF statement...here's my situation: I need the default value of a cell (C64) to be 8 as long as cells F24 and F25 contain text "n". If F24 text is "y" (F25 will remain "n"), then I need the value of C64 to be (8-I24). If the F25 text is "y" (F24 will remain "n"), then the value of C64 must be (8+I25). Is this possible to do within one cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data table around multiple scenarios | Excel Worksheet Functions | |||
| How to do if/then formula with multiple scenarios. | Excel Discussion (Misc queries) | |||
| consolidating results of multiple scenarios | Excel Discussion (Misc queries) | |||
| Return multiple scenarios | Excel Worksheet Functions | |||
| Multiple vendors and scenarios - Excel | Excel Worksheet Functions | |||
Linear Mode
