| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If result is...Then text is the answer
I need a formula that will give a text answer. I have the following, but
does not work. =IF(B70=0.01,"of Dev. Cost"),IF(B70=0.05,"of Equity") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If result is...Then text is the answer
Assuming that B70 can only be 0.01 or 0.05
=IF(B70=0.01,"of Dev. Cost","of Equity") -- Gary's Student "heater" wrote: I need a formula that will give a text answer. I have the following, but does not work. =IF(B70=0.01,"of Dev. Cost"),IF(B70=0.05,"of Equity") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If result is...Then text is the answer
One way:
=IF(B70=0.01,"of Dev. Cost,IF(B70=0.05,"of Equity","of something else") In article , heater wrote: I need a formula that will give a text answer. I have the following, but does not work. =IF(B70=0.01,"of Dev. Cost"),IF(B70=0.05,"of Equity") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "1235" appears as "One thousand two hundred thirty five" | Excel Discussion (Misc queries) | |||
| How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
| Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
| How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Hybrid Mode
