#VALUE! in 3 cells

  • Thread starter Thread starter Kayden
  • Start date Start date
K

Kayden

I have the following information in 3 cells:
=IF(H23-H24=0,"",H23-H24)
='Schedule of Values'!D28*0.9
=IF(H25-H26=0,"",H25-H26)
I am almost positive I have these written correctly, but
why do I get a #VALUE! in each of the cells?
 
=IF(H23-H24=0,"",H23-H24)
='Schedule of Values'!D28*0.9
=IF(H25-H26=0,"",H25-H26)
I am almost positive I have these written correctly, but
why do I get a #VALUE! in each of the cells?
Click to expand...

What is in H23, H24, H25, H26, and Schedule of Values!D28? Who put those
vlaues there, when, and how?

If any of these are text, you will get the #VALUE! error message.
 
Back
Top