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 5000G54000

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(G54000,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