Nested IF statements

March 22, 2009 at 21:06:15
Specs: Windows Vista, 128
Dear all,
Please help me to create nested if statements for below case:

in the colomn G there are 3 digit number: 110 (candy), 111 (cake), 112 (lollies) , 113 (choco) and so on
in the colomn A there are 4 digit number: 2100 (candy), 2200 (cake), 2300 (lollies), 2400 (choco) and so on

I want to create formula like sounds like this:
IF G1 is 110 then the result is 2100, if G1 is 111 then the result is 2000, if G1 is 112 then the result is 2300 and so on...

=IF(G1=110,2100,IF(G1=111,2200 and so on

Please help me...

Many thanks

See More: Nested IF statements

Report •

March 23, 2009 at 06:32:33
Keep going with your example. You've got the syntax exactly right.

Just keep in mind that Excel has a limit of 7 Nested IF's.

If you need more, DAGS on the subject. There are lots of websites with workarounds for the 7 Nested IF's limit.

Report •

March 23, 2009 at 06:45:51
DAGS i guess means Do A Goggle Search?

First time I've seen that particular abbreviation.


Report •

March 24, 2009 at 20:11:39
Dear derbydad03, thanks a lot for your response :) i didn't know that nested if statement has 7 limit ^^. well i'm now trying to use vlookup formula

Dear mike, i just knew also that DAGS means do a google search, cos when i type that the result is Department Accounting and General Service :p

Thanks all

Report •

Related Solutions

Ask Question