VALUE ERROR

E

Ed Davis

I have a sheet that is doing a calculation where I get a VALUE error.
In cell g5 the calculation is as follows:

=if(E5<>0,D5-E5,0)

The problem is that E5 also has a calculation that involes text. This is the
calculation

''=IF(ISERROR(INDIRECT("'"&TEXT($A7,"dd-mm-yy")&"'!$J$11")),"",INDIRECT("'"&TEXT($A7,"dd-mm-yy")&"'!$J$11"))


Thanks in advance for any help.
 
B

Bernard Liengme

Are the cells D5 and E5 both displaying numeric values?
For example, what is the result of = E5*2 and =D5*2?
best wishes
 
S

Shane Devenshire

Hi,

So it sounds like E5 can contain a non-numeric entry? If so then try

=IF(ISTEXT(E5),0,D5-E5)
 

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

Formula Does not work on excel 2003 10
VBA - exporting serial letters to single documents 0
Simple IF Statement Help! 3
Finding Date in an overseas format 21
INDIRECT as part of array 2
writing a value to a particular cell from function 3
Average every seven cells, then copy formula 2
Date conversion question 6

Top