ExcelBanter - If result is...Then text is the answer

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If result is...Then text is the answer (https://www.excelbanter.com/excel-discussion-misc-queries/85882-if-result-then-text-answer.html)

heater

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")

Gary''s Student

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")

JE McGimpsey

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")

All times are GMT +1. The time now is 09:57 AM.