I am looking for a formula that will; look to cell F288 and
if the number is between 50 and 499 the result will be 50 If it is outside that
range the result will be 0 (zero). Is this possible?
I am looking for a formula that will; look to cell F288 and
if the number is between 50 and 499 the result will be 50 If it is outside that
range the result will be 0 (zero). Is this possible?
Re: If statement for between two numbers
Please see below
Quote=IF(AND(F288<499,F288>50),50,0)
Re: If statement for between two numbers
=if(and(f288>50,f288<499),50,0)
Re: If statement for between two numbers
Hi Poliico,
=IF(AND(F288>=50,F288<=499),50,0)
Hope this helps.
Don’t have an account yet? Register yourself now and be a part of our community!