#1
|
|||
|
|||
#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. |
#2
|
||||
|
||||
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...
__________________
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 |
#3
|
|||
|
|||
Try like
Code:
= SUM($C$7,D6) |
|