Log in

View Full Version : Multiple IF's in "Insert function" bar



sindrefm
06-14-2015, 11:39 PM
Hi,

I am trying to use multiple IF sentences in the "Insert function" bar.
What I want:

Cell A2 to change according to code:

If(A1="BMW";3)
ELSIF(A1="Ford";4)
ELSIF(A1=.....)
...
END_IF

This wont work.. Can anyone help?

mancubus
06-15-2015, 07:55 AM
like?

US format:

=IF(A1="BMW",3,IF(A1="LAMBO",4,IF(A1="FERRARI",5,IF(A1="ASTON MARTIN",6,IF(A1="PORSCHE",7,"THAT'S ENOUGH")))))

Europe format:

=IF(A1="BMW";3;IF(A1="LAMBO";4;IF(A1="FERRARI";5;IF(A1="ASTON MARTIN";6;IF(A1="PORSCHE";7;"THAT'S ENOUGH")))))