Too many IF functions
 

Hey guys,

I have an IF statement that surpasses the amount of allowed IF's (7).
I have looked around and everyone seems to say to do a Vlookup but I
don't think that is what I want. Can you help me out?

This is the code:
================================================== ======================
=IF(F3="0 to < 4 feet Ditch and No Barrier",4,IF(F4="Concrete Barrier
without to < 2 feet Ditch",3,IF(F5="Guide Rail without to < 4 feet
Ditch",3,IF(F6="= 4 feet to < 8 feet Ditch",3,IF(F7="Light Duty
Netting",3,IF(F8="Concrete Barrier with = 2 Ditch",2,IF(F9="Guide
Rail with = 4 feet Ditch",2,IF(F10="Light Duty Fence",2,IF(F11="Heavy
Duty Fence",1,IF(F12="Heavy Duty Netting",1,""))))))))))
================================================== ======================

Thanks,
Molly
My website: http://techmolly.com

Too many IF functions
 

You're really checking F3, F4, ..., F12 for different strings?

If all of these are mutually exclusive (a maximum of exactly one could happen),
then:


=IF(F3="0 to < 4 feet Ditch and No Barrier",4,0)
+IF(F4="Concrete Barrier without to < 2 feet Ditch",3,0)
+IF(F5="Guide Rail without to < 4 feet Ditch",3,0)
+IF(F6="= 4 feet to < 8 feet Ditch",3,0)
+IF(F7="Light Duty Netting",3,0)
+IF(F8="Concrete Barrier with = 2 Ditch",2,0)
+IF(F9="Guide Rail with = 4 feet Ditch",2,0)
+IF(F10="Light Duty Fence",2,0)
+IF(F11="Heavy Duty Fence",1,IF(F12="Heavy Duty Netting",1,0)

This will actually return a 0 if non of these are true.


Molly wrote:

Hey guys,

I have an IF statement that surpasses the amount of allowed IF's (7).
I have looked around and everyone seems to say to do a Vlookup but I
don't think that is what I want. Can you help me out?

This is the code:
================================================== ======================
=IF(F3="0 to < 4 feet Ditch and No Barrier",4,IF(F4="Concrete Barrier
without to < 2 feet Ditch",3,IF(F5="Guide Rail without to < 4 feet
Ditch",3,IF(F6="= 4 feet to < 8 feet Ditch",3,IF(F7="Light Duty
Netting",3,IF(F8="Concrete Barrier with = 2 Ditch",2,IF(F9="Guide
Rail with = 4 feet Ditch",2,IF(F10="Light Duty Fence",2,IF(F11="Heavy
Duty Fence",1,IF(F12="Heavy Duty Netting",1,""))))))))))
================================================== ======================

Thanks,
Molly
My website: http://techmolly.com

--

Dave Peterson

Too many IF functions
 

On Aug 27, 10:33*am, Molly wrote:
Hey guys,

I have an IF statement that surpasses the amount of allowed IF's (7).
I have looked around and everyone seems to say to do a Vlookup but I
don't think that is what I want. Can you help me out?

This is the code:
================================================== ======================
=IF(F3="0 to < 4 feet Ditch and No Barrier",4,IF(F4="Concrete Barrier
without to < 2 feet Ditch",3,IF(F5="Guide Rail without to < 4 feet
Ditch",3,IF(F6="= 4 feet to < 8 feet Ditch",3,IF(F7="Light Duty
Netting",3,IF(F8="Concrete Barrier with = 2 Ditch",2,IF(F9="Guide
Rail with = 4 feet Ditch",2,IF(F10="Light Duty Fence",2,IF(F11="Heavy
Duty Fence",1,IF(F12="Heavy Duty Netting",1,""))))))))))
================================================== ======================

Thanks,
Molly
My website:http://techmolly.com

Nevermind, I figured it out.

Thanks though :)
Molly
My website: http://techmolly.com

Too many IF functions
 

Dave:

Thanks for showing me that. I figured it out with a VLookup but that
is very helpful for the future. Thank you very much for your response!

Molly
My website: http://techmolly.com