Excel formula help

[MikeyIs4Dcats]

I'm going cross-eyed! What is wrong with this formula????

=(IF($C$4<=500),23.50,(IF($C$4<=2000)),((($C$4-500)/100)*3.05),IF($C$4<=25,000),((($C$4-2000)/1000)*14),IF($C$4<=50000),((($C$4-25000)/1000)*10.10),IF($C$4<=100000),((($C$4-50000)/1000)*7),IF($C$4<=500000),((($C$4-100000)/1000)*5.6),IF($C$4<=1000000),((($C$4-500000)/1000)*4.75),((($C$4-1000000)/1000)*3.65))

 

[Haircut]

Without going through the whole formula, it looks as if you are using =IF() incorrectly

=IF(val>0,"positive","not positive") is the correct way to do it
=IF(val>0),"positive","notpositive" will produce an error.

This may be where you are going wrong.

 

[flamingelephant]

i wrote something like that once... boy did it suck...... dont have a copy with me though... out of town. wait 2 days ok?