Hi
Im looking for help using the IF function
I want A1 display the value from various cells depending on the value of B1.
For example, if B1 is 2.37 then I want to display the value of E1.
Now I know the formula for this is:
and if B1 is greater than 2.37 then display E2 is:
I also know to use the < sign within the formula.
What I want to know is how do I display a value of a cell if the cell in question needs to be between two different values. eg.
I want A1 to display the value of E3 if it is between 2.38 - 3. 56.
Thanks
Im looking for help using the IF function
I want A1 display the value from various cells depending on the value of B1.
For example, if B1 is 2.37 then I want to display the value of E1.
Now I know the formula for this is:
Code:
=IF(B1=2.37,E1,0)
and if B1 is greater than 2.37 then display E2 is:
Code:
=IF(B1>2.37,E2,0)
I also know to use the < sign within the formula.
What I want to know is how do I display a value of a cell if the cell in question needs to be between two different values. eg.
I want A1 to display the value of E3 if it is between 2.38 - 3. 56.
Thanks