Xgirl
=IF(A2<=100,A2*2,IF(A2<=200,A2*2.25,A2*2.5))

Dan Lieberman Wrote:
Wow thats an interesting equation. I didnt know Excel could do that
kinda
stuff!
If I put in 101 units, I got 227.25 so i dont think its working just
right
yet!! Going in the right direction though!!
thanks xgirl!!!
any ideas how to correct that??

dan

[/color][/color][/color]


hi dan i cant find a problem with this formula, if you use your
caculator you will find that 101*2.25 = 227.25, I have checked and
dubble checked the calulation.
well done Xgirl
Regards,
Jesse


--
Jesse_Norris
------------------------------------------------------------------------
Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546
View this thread: http://www.excelforum.com/showthread...hreadid=401339