re complex "IF" Formulas

P

Paul

I DID IT!!!!

Thanks very much everyone who helped, i really appreciate you taking
the time (special thanks to Cecil).

G-D I love the Internet!! :)

Here's what I ended up with:

=IF(L3<=8000,L3*30%,IF(L3<=12000,L3*40%,IF(L3<=20000,L3*43%,IF(L3<=40000,L3*50%,IF(L3<=100000,L3*55%)))))

Cheers,
Paul
 
Top