Thanks:  0
Likes:  0

# Thread: Formula for a fraction

1. 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.
~Christy

2. On 2002-03-09 13:26, Christy wrote:
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.
~Christy
42 divided by 0.6 is 70. I don't understand how you arrived at 26. Can you clarify?

3. The following seems to give the result you want, but I'd test it with other values also: -

=IF(INT(J16)<>J16,ROUNDUP(42*(J16-INT(J16)),0))

4. On 2002-03-09 13:26, Christy wrote:
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.
~Christy
Christy,

=IF(J16-INT(A16),ROUND(42/(J16-INT(J16)),0),0)

I get 70, not 26 when J16 is 12.6. Is that wrong.

5. Aladin, I think Mudface is on the right track. It appears she meant to say 42 * 0.6, not 42/0.6.

Take care

6. Thank you so much! I'm sorry for the mistake, it *is* supposed to be 42 *.06 and Mudface's answer works perfectly - Thank you all soooooo much!
~Christy

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•