Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Pivot Tables - do not display zero values | Excel Discussion (Misc queries) | |||
Excel 2007 - how do I display formula instead of values? thanks. | Excel Discussion (Misc queries) | |||
Excel 2007 Text Box Display and Printing | Excel Discussion (Misc queries) | |||
Excel 2007 Display value based on values in another column range | Excel Worksheet Functions | |||
How can I display a cell range in a text box in excel? | Excel Discussion (Misc queries) |