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
|