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