Results 1 to 2 of 2

Thread: Function if ex: a1=2 then b1=text1 b2=text2

  1. #1

    Function if ex: a1=2 then b1=text1 b2=text2

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Is there any option make if function for adding text to another cell: if i got a1=1 then fill with custom text only b1, then i get a2=2 then fill b1=text1 and b2=text2 ect.?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Are you asking for a function that will put a value in one cell if condition A is met, but a different cell if condition B is met? If so, no can do, a function returns a value to the cell that it is used within.

Posting Permissions

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