Ratio Rounding

[Andy Roberts]

I have used the following formula to calculate a ratio between two number.

=IF(J31=0,"",J31/GCD(J31:K31)&":"&K31/GCD(J31:K31))

How do I have the result rounded to 1 decimal place? I currently get
2:0.4444444444. I want to see 2:0.4

Andy
Excel 2007

 

[RagDyeR]

Try this:

=IF(J31=0,"",J31/GCD(J31:K31)&":"&ROUND(K31/GCD(J31:K31),1))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have used the following formula to calculate a ratio between two number.

=IF(J31=0,"",J31/GCD(J31:K31)&":"&K31/GCD(J31:K31))

How do I have the result rounded to 1 decimal place? I currently get
2:0.4444444444. I want to see 2:0.4

Andy
Excel 2007

 

[Andy Roberts]

Thats the kiddy!

Thanks

 

[RagDyeR]

You're welcome, and thanks for the feed-back.

 

[Andy Roberts]

Just one minor point

If I use =IF(J31=0,"",J31/GCD(J31:K31)&":"&ROUND(K31/GCD(J31:K31),1)) the
result is to 2 decimal places
If I use =IF(J31=0,"",J31/GCD(J31:K31)&":"&ROUND(K31/GCD(J31:K31),0)) the
result is to 0 decimal places

How do I get it to one decimal place?

Andy

 

[RagDyeR]

The last argument of the Round() function dictates the number of decimal
places.

The formula I suggested will only give you a *single* decimal place.

What numbers do you have in J31 and K31?

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Just one minor point

If I use =IF(J31=0,"",J31/GCD(J31:K31)&":"&ROUND(K31/GCD(J31:K31),1)) the
result is to 2 decimal places
If I use =IF(J31=0,"",J31/GCD(J31:K31)&":"&ROUND(K31/GCD(J31:K31),0)) the
result is to 0 decimal places

How do I get it to one decimal place?

Andy

 

[helene and gabor]

HELLO, did you get my reply?
(e-mail address removed)