Formula

L

Loretta

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
 
A

AAMIFC

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
 
Top