View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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")