If statement for between two numbers

Poliico · Nov 27th 2010

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?

madamson86 · Nov 27th 2010

Re: If statement for between two numbers

Please see below

Quote

=IF(AND(F288<499,F288>50),50,0)

Wigi · Nov 27th 2010

Re: If statement for between two numbers

=if(and(f288>50,f288<499),50,0)

**Batman** · Nov 27th 2010

Re: If statement for between two numbers

Hi Poliico,

=IF(AND(F288>=50,F288<=499),50,0)

Hope this helps.

If statement for between two numbers

Participate now!

Share