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.

Perhaps =IFERROR($C$7+D6,NA()) or =IF(TYPE($C$7)>1,NA(),$C$7+D6)
If using a pre 2007 version use IF(ISERROR...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Try like