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

M

Malaria Man

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?
 

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

N/A Error with VLOOKUP Formula - Excel 2007 6
Payment calculation 1
help with currency formula 9
if the value of a cell is between 2 values 4
Displaying text based on a formula 2
formula to display cell address 2
Checking a cell to see if it ISBLANK?? HELP PLEASE!!! 2
Excel won't resolve formula in one column 3

Top