Thread: Clearing #VALUE
View Single Post
  #1   Report Post  
skateblade
 
Posts: n/a
Default Clearing #VALUE

I get a #value in my total column W12, the formula is: =SUM(W11,U12,-V12) the
formula in the W11 column is the same. The formula in U12 is: =+N12, the N12
formula is: =-MIN(0,37.5-M12): The formual in V12 is: =+O12 the formula in
O12 is: =IF(M12=0,"",MAX(0,37.5-M12))
I would like the Total column W12 to get rid of #VALUE