Simple excel formula not so simple in 2010 anymore =\

[Zeus07]

Good afternoon everyone

I need some advice on a problem I have. I used to take the excel spreadsheets mailed to me by my PC suppliers, and simply add a new column with a formula to add VAT and markup to the supplier's price.
That was in Office 2003. Since then I used to simply carry that forumula in sheets along over the years...

..now I've lost it.

I tried to setup this formula in 2010, but it doesn't seem to be able to take the numerous IF-THEN-ELSE that I used to use.

Does anyone know how I can do this in Excel 2010?
It used to follow a route like IF CELL > 100000 THEN CELL*1.14*1.01 ELSE IF CELL>80000 THEN CELL*1.14*1.02

and so on. I havent used the correct syntax, that's just basically to show what I used to do.
That stupid little formula saved a lot of time, as I could simply add that column, hide the cost price column and print it out.

I would be SO HAPPY if anyone could help me out on this.
Thanks

 

[ABCpt]

Basic one: =IF(A1>10000,A1*1.14*1.01,A1*1.14*1.02)
else
http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/

 

[Richardxtc]

=IF(A1>=100000,A1*1.14*1.01,IF(A1>=80000,A1*1.14*1.02,""))

 

[GPSJane]

Maybe post the full set of conditions and we can help do it for you.

 

[HavocXphere]

This works

=IF(A4>0,"A",IF(A4>2,"B",IF(A4>3,"C",IF(A4>4,"D"))))

This doesn't

=IF(A4>0,"A",IF(A4>2,"B",IF(A4>3,"C",IF(A4>4,"D","X"),"X"),"X"),"X")

Weird. Not sure wtf is up with that. Should work according to std Excel theory.

 

[Cage Rattler]

=IF(A4>4,"D",IF(A4>3,"C",IF(A4>2,"B",IF(A4>0,"A","X"))))

 

[HavocXphere]

Clever. The original should theoretically work too though.