Greater than, less than formula

  • Thread starter Thread starter James O'Toole
  • Start date Start date
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
 
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
 
Back
Top