LinkBack URL
About LinkBacks
Try this:
=IF(A1="", "N/A", A1 & "FT")
Try this:
=IF(A1="", "N/A", A1 & "FT")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
J,
Thanks a lot for your help, but when the value of A1 is 0, B1 is reporting "0FT" and not "N/A." It's very close to a solution though because I did notice that if the A1 is empty then B1 reports "N/A." It's just not doing it for zeros.
Any ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks