I am trying to do a basic formula: If cell equals, then make another cell equal to another value. For example, I am using in cell B1: =IF(A1="JSMITH/NET Pay","Yes","No"). However, it is not working even though the value in A1 is as written. B1 returns value of "no" instead of "yes". If I put simple text in A1 (without a slash (/) mark) the formula works. It seems the slash (/) mark is being read as a division symbol?
Thanks!
Last edited by sos4excel; 11-04-2014 at 11:35 AM.
No. This is not your problem. Check for trailing spaces in A1.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you so much for helping me with my first post--trailing spaces were there!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks