assuming data is located at cell A1Example, one cell = 17.2 then in the Ball cell needs to equal 17 times 6 + 2
=INT(A1)*6 + (A1-INT(A1))*10
assuming data is located at cell A1Example, one cell = 17.2 then in the Ball cell needs to equal 17 times 6 + 2
=INT(A1)*6 + (A1-INT(A1))*10
Awesome, thank you very Much
Theres so much i need to learn with spredsheet lol
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks