More than 1 outcome for and IF

S

Steveandshelly

I want to set a formula to calculate the following. I want to analyse a
number.

If it is less than £25,000 insert 0
if it is between £25,000 and £50,000 multiply (number -£25,000)by
55%
If it is more than £50,000 assume it is £50,000 and multiply
(50,000-£25,000)by 55%

I'm sure this is straight forward but I couldn't find a way to use IF,
nor an alternative.

Thanks in advance.
 
N

Niek Otten

One of many ways:

=IF(A1<25000,0,MIN(A1,50000)-25000)*55%

--
Kind regards,

Niek Otten

I want to set a formula to calculate the following. I want to analyse a
number.

If it is less than £25,000 insert 0
if it is between £25,000 and £50,000 multiply (number -£25,000)by
55%
If it is more than £50,000 assume it is £50,000 and multiply
(50,000-£25,000)by 55%

I'm sure this is straight forward but I couldn't find a way to use IF,
nor an alternative.

Thanks in advance.
 
S

Steveandshelly

Thanks, Don't understand what it is doing but it definitely works.

Much appreciated.

Steve
 
N

Niek Otten

Hi Steve,

A more straightforward way to write that:

=IF(A1<25000,0,IF(A1>50000,25000*55%,(A1-25000)*55%))
 
W

wjohnson

You can also try the following:
=IF(A1<325000,0,IF(AND(A1>=325000,A1<=350000),(A1-325000)*55%,IF(A1>350000,(A1-325000)*55%,"Check")))
The last Item "CHECK" can be changed to whatever you want - It is th
last indicator if none of the other conditions are met, i.e someon
typed some letters where numbers should be
 
Top