Formula works in some cells of a colum but not others?

G

Guest

Hi! I have a formula applied to a column that is giving the correct results in some cells but not in others.

My first error is in J13 which shows an incorrect result of 1271. It should be 1260
J13 has formula: =IF(H13<=0,0,(H13*30)
H13 has a formula: =IF(F13=0,0,(($H$5*60)/D13)*F13) with a result of 42 (correct
H5 is 12 (no formula
D13 has formula: =IF(B13<=0,0,(B13+5)) with a result of 17 (correct
F13 has formula: =ServiceInv!B7 with a result of 1 (correct
B13 is 12 (no formula

Can anybody help me?!?! I'm going crazy!! Thanks!
 
J

Jerry W. Lewis

Answered under the request you posted 5 minutes earlier. Be patient,
newsgroups are users helping other users. Since no one is paid to
provide answers here, you will get an answer when someone gets around to
it, and not before.

Jerry
 

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 not producing correct result 2
Why Am I getting a blank in the result cell? 4
Formula Not Calucating Right 2
Sumproduct formula won't calculate... 2
Formula appears, but its function is not performed????? 1
Array formula returns blank in the cell where it is entered 1
Formula omits adjacent cells error message 4
formula errors in existing file after updating to Office 2003 2

Top