About Us

tame06

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Simple IF statement	Bob[_16_]	Excel Discussion (Misc queries)	4	March 30th 10 07:12 PM
simple IF statement	Gemz	Excel Programming	5	March 6th 08 09:42 AM
Simple IF statement	Steve Douglas P2p, MCP	Excel Worksheet Functions	4	September 10th 07 12:32 PM
Simple if statement?	[email protected]	Excel Programming	4	October 30th 06 11:45 PM
Simple If Statement	DM	Excel Programming	2	July 27th 04 08:26 PM

Menu

About Us