Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
I have these colums
--B c d e f Total 1/3ofB-1/3ofB-1/3ofB- Total of c d e B & f should be the same amount How do I get 1/3 of B to enter in c,d,&e? Loretta |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Not sure if this is what you are after:
You can use the same formaula for columns C, d and e =$B(row)/3 replace (row) with the row number. eg: Row B C D E F 1 15 =$b1/3 =$b1/3 =$b1/3 =sum(C1:E1) Result will be: Row B C D E F 1 15 5 5 5 15 Hope this helps "Loretta" wrote: I have these colums --B c d e f Total 1/3ofB-1/3ofB-1/3ofB- Total of c d e B & f should be the same amount How do I get 1/3 of B to enter in c,d,&e? Loretta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|