How Can Make equation With IF X>Y>z

A

Ahmed R

How can I make equation including a number between another two numbers
EXP:

if the number in the cell 5000>G5>4000
 
S

steve

How can I make equation including a number between another two numbers
EXP:

if the number in the cell 5000>G5>4000
Click to expand...

You seem to be trying to determine if a variable (number) in Cell G5
is greater than 4000 and less than 5000. The formula would be:

=IF(AND(G5>4000,G5<5000),{TRUE},{FALSE})

where

{TRUE} is what you want to happen if the result is TRUE
{FALSE} is what you want to happen if the result is FALSE
 
Top