#VALUE! in 3 cells

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

Jonathan Rynd

=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.
 
Top