+ Reply to Thread
Results 1 to 3 of 3

If result is...Then text is the answer

  1. #1
    heater
    Guest

    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. #2
    Gary''s Student
    Guest

    RE: 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. #3
    JE McGimpsey
    Guest

    Re: 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 <[email protected]>,
    heater <[email protected]> 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1