#value!

		Microsoft Office Forums > Microsoft Excel > Excel
#value!

FAQ

Thread Tools

Display Modes

08-05-2019, 06:57 PM

Karen615

Windows 7 64bit #value!

Office 2010 64bit

Competent Performer

Join Date: Jun 2011

Location: Chicago

Posts: 145

#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.

« Previous Thread | Next Thread »

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 PM.