Greater than, less than formula

J

James O'Toole

Hi there,

I am trying to calculate a formula but need some help! I
need to enter a formula that if the value in a cell is
greater than £15,000 but less than £30,000 it will
multiply that value by 1%. Eg if the value was £12,000 or
£35,000 no calculation would be made but if it was £25,000
it would be multiplied by 1%. I can get as far as if the
formula is higher than £15,000 it will multiply by 1% but
I cannot work out how to bring in the less than £30,000
part of the formula. At the moment anything over £15,000
is being multiplied by 1%, up to any value.

Any help would be much appreciated.

James
 
A

Alan

With the value in G12,

=IF(AND(G12>15000,G12<30000),G12*1.01,G12)
or
=IF(AND(G12>=15000,G12<=30000),G12*1.01,G12)

Regards,
Hi there,

I am trying to calculate a formula but need some help! I
need to enter a formula that if the value in a cell is
greater than £15,000 but less than £30,000 it will
multiply that value by 1%. Eg if the value was £12,000 or
£35,000 no calculation would be made but if it was £25,000
it would be multiplied by 1%. I can get as far as if the
formula is higher than £15,000 it will multiply by 1% but
I cannot work out how to bring in the less than £30,000
part of the formula. At the moment anything over £15,000
is being multiplied by 1%, up to any value.

Any help would be much appreciated.

James
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Minimum/Maximum 2
FORMULA TO CALCULATE VARYING SALES COMMISSIONS 2
writing a greater than/less than formula 7
Greater than but less than formula 3
Greater than AND Less than Time Q 2
Calculating a Formula Subject to a Maximum and Minimum Value 2
Excel Average dates help 0
Greater Than but Less than 5

Top