Thread: #value!
View Single Post
 
Old 08-05-2019, 06:57 PM
Karen615 Karen615 is offline Windows 7 64bit Office 2010 64bit
Competent Performer
 
Join Date: Jun 2011
Location: Chicago
Posts: 145
Karen615 is on a distinguished road
Default #value!

I have the following formulas:
For example

=$C$7+D6
=$C$7+E6


What do I add to these formulas so the cell returns N/A if a non-numeric value is added to D6 or E6?


Your help is greatly appreciated.
Reply With Quote