Put a check in the formula in col H to see if anything is in it. I am not
sure what your formula is column H is trying to do in the OR statement. What
is E1125 suppose to be checking.



"Richard" wrote:

F column works fine, H column will only work if there is something in A
column otherwise H column gives me the #VALUE! error

F column has:
=If(OR(B1125<"\\\\\\CC\\\\\\",A1125=""),"",ROUNDU P(E1125,0)-E1125)
H column has: =(IF(OR(E1125,G11250),H1124-E1125-F1125+G1125,""))

Thanks ih advance!