Posted to microsoft.public.excel.misc

dave glynn dave glynn is offline

external usenet poster

Posts: 6

nested ifs

Cell C1 takes is value from any one of three other cells depending on the
value of cell B4. The if statement I should like to writr would go something
like this

if(b4=1,b1&if(b4=2,b2&if(b4=3,b3)))

Is this syntax correct?

Many thanks

Dave

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nested IF with a possible SUM?	Princessl210	Excel Discussion (Misc queries)	1	April 8th 08 07:56 AM
nested if based on nested if in seperate sheet. how?	scouserabbit	Excel Worksheet Functions	5	March 2nd 07 04:03 PM
Nested Ifs	Amy	Excel Worksheet Functions	3	October 9th 06 01:54 AM
Nested IF	Ed Ferrero	Excel Discussion (Misc queries)	4	November 27th 05 05:31 PM
Nested If with And	TheLeafs	Excel Worksheet Functions	2	August 24th 05 05:24 PM

All times are GMT +1. The time now is 03:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us