Hi,
I would like to calculate the following:
Cell B2 is where value is entered
Cell G2 where if formula needs to stay.
When value in B2 is less than 1600 than nothing, when value is greater than or equals to 1600 and less than or equals to 3201, then (B2 -1600) * .0275, if it is above 3201 then nothing.
So, here there is range from 1600 until reaches 3201 where calculation needs to be done, everything out of this range is zero.
I tried this but it doesn't work.
Thanks.
I would like to calculate the following:
Cell B2 is where value is entered
Cell G2 where if formula needs to stay.
When value in B2 is less than 1600 than nothing, when value is greater than or equals to 1600 and less than or equals to 3201, then (B2 -1600) * .0275, if it is above 3201 then nothing.
So, here there is range from 1600 until reaches 3201 where calculation needs to be done, everything out of this range is zero.
I tried this but it doesn't work.
Code:
=IF(AND(B2>=1600,B2<=3201),"",(B2-1600)*0.0275,0)
Thanks.