# formula problem based on answer

1. ## 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

2. ## Re: formula problem based on answer

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 ???

3. ## Re: formula problem based on answer

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

5. ## Re: formula problem based on answer

Hello, You can use this:

Formula:
`Please Login or Register  to view this content.`

6. ## Re: formula problem based on answer

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1