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