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

if the number in the cell 5000>G5>4000

On Sep 20, 9:12*pm, Ahmed R <Ahmed R @discussions.microsoft.com>
wrote:
> How can I make equation including a number between another two numbers
> EXP:
>
> if the number in the cell 5000>G5>4000

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