View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Help with formula

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!