Ratio equation in excel?

1 ⤊

Ratio equation in excel?

How do you make an equation for excel that makes the short ratio for two cells? i.e. a1=4 b1=8 so the ratio would be 1:2. So how do you write that in a function?

2006-11-28 08:17:12 · 2 answers · asked by canajen 2 in Computers & Internet ➔ Software

2 answers

Load the Analysis Toolpak add-in and then use this formula, it's shorter:

=A1/GCD(A1, B1)&":"&B1/GCD(A1, B1)

2006-11-28 11:15:06 · answer #1 · answered by O Caçador 6 · 1⤊ 0⤋

=(LEFT(TEXT(A1/B1,"####/####") , FIND("/",TEXT(A1/B1,"####/####"))-1) & ":"&RIGHT(TEXT(A1/B1,"####/####") , LEN(TEXT(A1/B1,"####/####")) - FIND("/",TEXT(A1/B1,"####/####" ))))

Edited to add: This formula allows for a four-character limit.

2006-11-28 17:51:08 · answer #2 · answered by Anonymous · 0⤊ 0⤋