Hello All,
I need a formula in cell U24 that will look at the result in cell J16 and, if it sees a fraction, it will divide only the fraction part of the number into 42.
Here's an example:
cell J16 contains 12.6
cell U24 will divide 42 by .6, round that result up to nearest whole number
and display 26
If cell J16 contains a whole number with no decimal, cell U24 will display 0.
Thank you so much for any help you can provide!
~Christy
I need a formula in cell U24 that will look at the result in cell J16 and, if it sees a fraction, it will divide only the fraction part of the number into 42.
Here's an example:
cell J16 contains 12.6
cell U24 will divide 42 by .6, round that result up to nearest whole number
and display 26
If cell J16 contains a whole number with no decimal, cell U24 will display 0.
Thank you so much for any help you can provide!
~Christy