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

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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
 
Back
Top