One way

=IF(A1=100,ROUND((1.25*A1)/25,0)*25,IF(A1<50,75,150))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"kdw" wrote in message
...
I am trying to come up with a formula where if a value is this then the
result should be this. ex
if A1 is between 0 - 49 then the result should be 75
if a1 is between 50 - 99 then the result should be 150
if a1 is over 100 then the result should be 125% of a1 rounded to the
nearest 25.

I thought that maybe I should separate to above and below 100 and then do
separate formulas but for some reason =lookup(a1,{0,50;75,150}) is not
working for the smaller group and the formula for the second group is
totally
baffling me.

Any help out there??

thank you in advance