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, which contains a sentence)

Else, new cell D5 equals information from another cell (F5, which 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. Thanks

Hi There,

I would try doing this in two steps which would require a spare cell 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 value (5,25,50) appeared.

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

Hopefully that makes sense.

Goodluck.

"pugswagger" wrote:
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)

What about the OR function!