Excel, IF fuction with cell text values?
Solved/Closed
Related:
- Excel, IF fuction with cell text values?
- Excel if range of cells contains specific text then return value ✓ - Forum - Excel
- Excel file path in cell - Guide
- Excel vba msgbox when cell meets criteria ✓ - Forum - Excel
- Excel formula if two cells match return value from third ✓ - Forum - Excel
- Excel color row if cell contains text ✓ - Forum - Excel
1 reply
rizvisa1
May 26, 2010 at 05:23 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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!