IF formula and #VALUE! returns

J

JWB

Joined
Mar 14, 2006
Messages
2
Reaction score
0
I am developing a spreadsheet, which contains numeric entries as well as text.



The problem I have is that I have used an IF formula which will leave a destination cell blank if no numeric data is entered in to the source cell. However when I enter text I get a #VALUE! error in the destination cell.



Is there anyway of overcoming this problem?

Any assistance would be appreciated.

Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Formula & #VALUE! error 0
If Function 1
Source and Destination worksheet difference 5
Calculation using IF 6
Calculation using IF 1
#value error for sumproduct using RIGHT cmd 0
Testing a cell value for a specific weekday. 3
Conditional formatting based on formula cell 6

Top