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?

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?

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?

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?