How Can Make equation With IF X>Y>z

  • Thread starter Thread starter Ahmed R
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

multiple 3D equations in one excel surface chart 1
Linking the Regression equation of a line to a table 1
Problem with an equation. 3
How do I calculate the z factor automatically 1
Matrix inverse with MInvers, help please. 1
Matrix ANALYSIS 1
Evaluate Equation in VBA 3
Excel 2003 drawing Trend lines on a chart for a given set of point 1

Back
Top