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