View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
radellaf radellaf is offline
external usenet poster
 
Posts: 8
Default Merged cells and formula data sources

in c1: =A1*B1
in c2: =IF($A2=0,($C1/$B1)*$B2,$A2*$B2)

Copy down


=IF($A2=0,$A1*$B2,$A2*$B2) does work.

However, when it reaches areas with the triple merge
e.g., (A3/A4/A5) to equal A3*Bx
there are two problems. Copy down puts A5*B5 in C5, and the IF only looks
at two cells. Perhaps the IF could be nested and handle, say, up to 5
merged, but copy-down would still fail...

Thanks, though!