Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Two cells divided into next cell
Hope this makes sense. I have F column that totals down to F16. Then I have a total on D16. I need both totals to be divided and show up on G16. Every cell has $ Amts, but the only cells not totaled down the row are E,G and J. So G16 is blank. Is this possible to do and If so how. I don't even know the formula to Divide and I need this to automatically happen every time I Insert the Amts in the cells. Please help |
#2
|
|||
|
|||
In G16:
=D16/F16 "Day" wrote in message ... Hope this makes sense. I have F column that totals down to F16. Then I have a total on D16. I need both totals to be divided and show up on G16. Every cell has $ Amts, but the only cells not totaled down the row are E,G and J. So G16 is blank. Is this possible to do and If so how. I don't even know the formula to Divide and I need this to automatically happen every time I Insert the Amts in the cells. Please help |
#3
|
|||
|
|||
Thank you this did help but I just ran into a problem. When I started
inputting the formula into each cell to calculate what I wanted I noticed that on my next month column where It's blank, that only that whole column automatically calculates what I want. I need all colums to automatically do what the above cells are doing. How do I get the next three columns to do what the above are doing and what the blank one will do when I input a number. I inputted fake numbers to see if they will automatically calculate and that's when I noticed the problem. If you understand please let me know if you have any ideas. Thanks, Day "PCLIVE" wrote: In G16: =D16/F16 "Day" wrote in message ... Hope this makes sense. I have F column that totals down to F16. Then I have a total on D16. I need both totals to be divided and show up on G16. Every cell has $ Amts, but the only cells not totaled down the row are E,G and J. So G16 is blank. Is this possible to do and If so how. I don't even know the formula to Divide and I need this to automatically happen every time I Insert the Amts in the cells. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenating cells to produce a cell ref from another excel file | Excel Worksheet Functions | |||
Need to find the right-most cell value in a string of cells | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |