Excel 2007 - formula to display text over a range of values
 

Another formula creates the value of D18. In cell E18 I want to write a
formula. In that formula, if the value of cell D18 is between a set of
numbers, like between 60 & 70 then display "TEXT" in E18. If the value of
cell D18 is between 0 & 59 or between 71 & infinty, then I want
"DIFFERENTTEXT" displayed in E18.
I can get this to work on one specific # with the If formula in this example.
=If(D18=60,"TEXT",DIFFERENTTEXT")
The value of Cell D18 will be in tenths and I do not want to keep adding If
formulas for ever tenth between 60.0 and 70.0.
Any solutions?

Excel 2007 - formula to display text over a range of values
 

=If(AND(D18=60,D18<=70),"TEXT",DIFFERENTTEXT")
--
If this helps, please remember to click yes.


"Malaria Man" wrote:

Another formula creates the value of D18. In cell E18 I want to write a
formula. In that formula, if the value of cell D18 is between a set of
numbers, like between 60 & 70 then display "TEXT" in E18. If the value of
cell D18 is between 0 & 59 or between 71 & infinty, then I want
"DIFFERENTTEXT" displayed in E18.
I can get this to work on one specific # with the If formula in this example.
=If(D18=60,"TEXT",DIFFERENTTEXT")
The value of Cell D18 will be in tenths and I do not want to keep adding If
formulas for ever tenth between 60.0 and 70.0.
Any solutions?