I need a formula based on several cells
I have 7 cells, most of the time not all 7 will be used in a 12 hour shift
B14
J14
R14
Z14
AH14
AP14
AX14
In those cells the numbers are 54000 or higher, but I only want 52000 of each cell to be tabulated into the BN12 cell (tonnage)
Once you get the 52000 for each completed cell, then it's needs to be multiplied by 0.0011 to determine the total tonnage.
For example, if 3 of the 7 cells are used. B14, J14, R14
Then I need it to take 52000x3 which is 156000 times 0.0011 for BN12 to show 171.6 tons
And if 4 of the 7 cells are used, B14, J14, R14, Z14, then that's 208000 x 0.0011 for a total of 228.8 tons in BN12
Or I could do 57.2 tons per completed cell for the tonnage in the B12 cell.
I hope I'm clearly explaining this, I appreciate any feedback.
Thanks everyone.
Bookmarks