Excel, IF fuction with cell text values?
Solved/Closed
Related:
- Excel, IF fuction with cell text values?
- Excel formula if cell contains text then return value in another cell ✓ - Excel Forum
- Excel date format dd.mm.yyyy - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel if cell contains date ✓ - Office Software Forum
- Excel free download - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 26, 2010 at 05:23 AM
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
=IF((B19-B12)<0,"To Pay to " & A3, "Owed To company")
You should not have "& A3", that makes it a string
May 26, 2010 at 05:30 AM
I've been struggling with this for some time today, such an easy thing to change, but I would never guess it!