Thanks, how do I set formulate it to read the .15 and then add that to the =INT(A1*16)?
Because the .15 will be different in other cells, do I have to first separate the 1.15 into two cells A1: 1.15 , (A2: 1 , B2: 15) and then add them up? (C2=A2+B2)?
Example:
A1: 4.06 (this should equal out to: 4x16+6 = 50)
A2: 1.13 (1x16+13 = 29)
A3: 2.00 (2x16+0= 32)
A4: 3.14 (3x16+14= 62)
Thanks for the help!
Bookmarks