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 |
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 |
All times are GMT +1. The time now is 01:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com