Excel, IF fuction with cell text values? [Solved/Closed]

Question

Excel, IF fuction with cell text values? [Solved/Closed]

Report

jen - May 26, 2010 at 04:39 AM
jen - May 26, 2010 at 05:30 AM

Hello,

I would like to include the text value of a cell in the statement I have for one of the IF options.

So far my formula is -:

=IF((B19-B12)<0,"To Pay to Employee, "Owed To company")

However I would like to change the employee to a cell value A3, where their name is in text.

=IF((B19-B12)<0,"To Pay to "&A3", "Owed To company")

But this doesn't work....

Would love your suggestions!

Excel, IF fuction with cell text values?
Excel file location in cell - How-To - Excel
Excel formula to clear cell contents - How-To - Excel
Excel copy row if cell contains certain text ✓ - Forum - Excel
Excel conditional formatting if cell contains specific text ✓ - Forum - Excel
Excel formula to copy cell value from another sheet ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Answer 1 · 2010-05-26T05:23:28-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

761
May 26, 2010 at 05:23 AM

Change to

=IF((B19-B12)<0,"To Pay to " & A3, "Owed To company")

You should not have "& A3", that makes it a string

Report

jen
May 26, 2010 at 05:30 AM

thank you very much!

I've been struggling with this for some time today, such an easy thing to change, but I would never guess it!

Excel, IF fuction with cell text values? [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!