| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto calculate absolute cell reference
Why don't you enter 200 directly into cell B24 (formatted as currency,
so the $ symbol will appear automatically), then have a formula in B23 like: =IF(B24="","",B24/B3) Hope this helps. Pete On Mar 5, 8:38 pm, Teri wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto calculate absolute cell reference
Probably because my brain has turned to mush. That's perfect!!! Thanks so
much for your help :) "Pete_UK" wrote: Why don't you enter 200 directly into cell B24 (formatted as currency, so the $ symbol will appear automatically), then have a formula in B23 like: =IF(B24="","",B24/B3) Hope this helps. Pete On Mar 5, 8:38 pm, Teri wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto calculate absolute cell reference
You're welcome - thanks for feeding back.
Pete On Mar 5, 8:53 pm, Teri wrote: Probably because my brain has turned to mush. That's perfect!!! Thanks so much for your help :) "Pete_UK" wrote: Why don't you enter 200 directly into cell B24 (formatted as currency, so the $ symbol will appear automatically), then have a formula in B23 like: =IF(B24="","",B24/B3) Hope this helps. Pete On Mar 5, 8:38 pm, Teri wrote: 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- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
| What is the key shortcut for absolute cell reference? | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| Absolute Cell Reference | Excel Discussion (Misc queries) | |||
| Absolute cell reference question | Excel Worksheet Functions | |||
Linear Mode
