Hi Everyone,
I am trying to figure out the formula required to use in an Excel spread sheet.
I have two numbers, one wth decimal places and one without. I need to multiply both numbers by the same value to reach the nearest whole number in both columns. Hope I am making sense
example (from my computer program)
Thank you
I am trying to figure out the formula required to use in an Excel spread sheet.
I have two numbers, one wth decimal places and one without. I need to multiply both numbers by the same value to reach the nearest whole number in both columns. Hope I am making sense
example (from my computer program)
6.25 | 1 | = | 25 | 4 |
1 | 2.540 | = | 50 | 127 |
Thank you