Greater than but less than formula

Guest · Jul 11, 2007

Hello.

Is there a formula that will allow me to do a certain function if:
the value of a cell is (for example) greater than 5 but less than 8?

I appreciate any help.

Thanks,
Storm

Guest · Jul 11, 2007

=if(and(A1>5,A1<8),true,false)

Guest · Jul 11, 2007

Thank you very much!

Toppers said:
=if(and(A1>5,A1<8),true,false)

Guest · Jul 11, 2007

No need IF function

AND(A1>5,A1<8)

Toppers said:
=if(and(A1>5,A1<8),true,false)

Excel Average dates help	0	Feb 12, 2014
Formula	9	Jul 26, 2008
Excel Need Countifs Formula Help	0	Apr 24, 2021
Excel Formulas "Not Greater than"	3	Feb 1, 2007
Using greater than and lesser than formula	2	May 28, 2009
Greater than AND Less than Time Q	2	Mar 9, 2009
Greater Than but Less than	5	Oct 18, 2006
If formula	3	Sep 30, 2009

Greater than but less than formula

Guest

Guest

Guest

Guest

Ask a Question

Similar Threads