greater than or less than if statements

G

Guest

How do you make a formula to state if a number is greater than one number but
less than another number. My example is: if d10 is greater than b20 but less
than b20+1, then b10, if not, b20.
 
B

Bob Phillips

=IF(AND(D10>B20,D10<B20+1)<B10,B20)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
G

Guest

ERG said:
How do you make a formula to state if a number is greater than one number but
less than another number. My example is: if d10 is greater than b20 but less
than b20+1, then b10, if not, b20.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I get a result if one cell is X and the 2nd cell is Y where 5
Excel Conditioning Formatting 3
If, and, or conditional formulas together 4
Excel Average dates help 0
Using If function for Great and less than function 6
Multiple If (Lookup?) Statement 7
Multiple logic tests 0
Greater than AND Less than Time Q 2

Top