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

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.
 

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

Top