formula problem based on answer

Hi guys

what i need to do is
in cell p45 i need it to return these answers based on whats in cell p49

so if p49 is between £0.00 and £25,000 then cell p45 should return £29
if cell p49 is between £25,001 and £50,000 then cell p45 should return £58

but if cell p49 is between £50,001 and £200,000 then it needs to return 0.5% of that value
all help gratefully received

Try
=IF(P49<=25000,29,IF(P49<=50000,58,0.005*P49))

No check on upper limit of 200,000: what if it is > 200,000 ???

Hi John

I will cross that bridge as and when but the true reality is that its unlikely to happen for now.
Thank you so so much

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Hi

I think this covers all your options:
=IF(P49>200000,"Unknown",IF(P49>50000,P49*0.05,IF(P49>25000,58, IF(P49>=0,29, IF(P49<0,"Unknown"))))).

Regards
Alan