View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teri Teri is offline
external usenet poster
 
Posts: 77
Default Auto calculate absolute cell reference

I'm not sure that I phrased the "subject" correctly, but here is what I need
to do. I do a P&L Analysis for our company for the 25+ locations we have.
What I must do is enter 200 in cell B23, and it must be automatically divided
by the value in A3. Then, the value of $200 automatically is entered in B24.
Is this even possible?

A B
3 Sales $10,000
23 Claims % =200/B3
24 Claims $ $200