View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
crimsonkng
 
Posts: n/a
Default why am I getting a #VALUE! error?

Hopefully, this is the correct forum in which to ask this question.

In Cell K320, when the formula is
=K182
I get a blank (zero)

But when the formula in in that same cell is
=K182+IF(A440,($J$202/$U$202)/12,0)
I get a #VALUE! error

A similar formula in Cell K308
=SUM(K158:K178)+IF(A150,($J$202/$U$202)/12,0)
works fine.

I can't figure out why it's not working in K320.

Thanks, in advance, for any help you can provide.

Dan