Posted to microsoft.public.excel.misc

Lorne[_2_] Lorne[_2_] is offline

external usenet poster

Posts: 44

How do I nest more then 7 IF's?

"KenCanuck" wrote in message
...
HI Bob, essentially I have a row of 13 dollar figures, and my formula goes
like this... =if(k1=a1,a2,if(k1=b1,b2,if(k1=c1,c2,... Another way to do
that where I don't nest 13 IF's?? Thanks

Look at the HLookup formula. using the range A1..J2 it will find a value in
row 1 and return the value from the same col in row 2.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Nest IF....maybe? IF/AND??	Leigh	Excel Discussion (Misc queries)	6	December 13th 07 11:03 PM
NEST A IF WITHIN A IF	Karine	Excel Worksheet Functions	4	November 27th 07 10:11 PM
Too Many If's	Rianne	Excel Worksheet Functions	10	March 22nd 07 08:13 PM
IF's	karensa	Excel Worksheet Functions	4	December 27th 06 10:05 PM
7+ Nest If's	Channing	Excel Worksheet Functions	9	January 22nd 05 08:53 PM

All times are GMT +1. The time now is 04:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us