Previous Topic Next Topic

Excel, IF fuction with cell text values?

Solved/Closed
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!


1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
0
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!
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses