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.
Quote:
Originally Posted by 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, 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
|