Announcement

Collapse
No announcement yet.

If Cell Equals Text Then Return Another Cell

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • If Cell Equals Text Then Return Another Cell

    I need a formula that If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell...


    at the mo i've got

    =IF(A2="PAID OUT", "OK", "Not OK")

    but instead of the cell reading OK or Not OK, i need it to equal another cell. ie, if A2="PAID OUT", then =B2



    how do i do that?

  • #2
    Re: If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell?!

    Hi,

    =IF(A2="PAID OUT", B2, "Not OK")

    Eric

    Comment


    • #3
      Re: If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell?!

      and cue Dave...

      ;-)

      Comment

      Working...
      X