VALUE ERROR

  • Thread starter Thread starter Ed Davis
  • Start date Start date
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.
 
Are the cells D5 and E5 both displaying numeric values?
For example, what is the result of = E5*2 and =D5*2?
best wishes
 
Hi,

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

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