Simple IF Statement Help!

[pugswagger]

Hello everyone,

I wanted to construct an IF statement that does the following:

IF cell (A5) equals any of these values (50 or 25 or 5)

Then new cell D5 equals information from another cell (E5, whic
contains a sentence)

Else, new cell D5 equals information from another cell (F5, whic
contains a sentence also)

(NOTE: D5 is on another sheet)

My original formula was

=if('PLAN ID'!A5="50,25,5",calculation!C7 & " " & calculation!F7 & "
&calculation!I7 *<--Sentence from E5*, calculation!e8 & " "
calculation!i8 *<-- Sentence from F5*)

Any help will be greatly appreciated. Thank

 

[tame06]

Hi There,

I would try doing this in two steps which would require a spare cel
somewhere. Call this spare cell S1

In the spare cell (S1) I would use;

=if(A5=5, 1, if(A5=25, 1, if(A5=50, 1, "")))

This would give you a "1" in that cell for everytime the desired valu
(5,25,50) appeared.

Then in cell D5 I would use;
=if(S1=1, E5, F5)

Hopefully that makes sense.

Goodluck.

 

[joeu2004]

IF cell (A5) equals any of these values (50 or 25 or 5)
Then new cell D5 equals information from another cell
(E5, which contains a sentence)
Else, new cell D5 equals information from another cell
(F5, which contains a sentence also) [....]
My original formula was
=if('PLAN ID'!A5="50,25,5",

Based on your English description, try:

=if(or('PLAN ID'!A5={50,25,5}),E5,F5)

 

[Kevin@Radstock]

What about the OR function