# Ratio Computation

#### mark692

##### Active Member
Hello guys i have a small laundry business, i want to know the ratio between the numbers of wash and the number of detergent used per day, i have i table like this

ABCD
1DateWashDetergentRatio
2August, 01 201864
3August, 02 201853
4August, 03 201842
5August, 04 2018
6August, 05 2018
7August, 06 2018
8August, 07 2018
9August, 08 2018
10August, 09 2018
11August, 10 2018

<tbody>
</tbody>
Sheet1

on column D i to put wer the ratio will appear

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

##### Board Regular
hope this works
Code:
``````Date               	Wash	Detergent	Ratio
August, 01 2018      	6       	4	3:2
August, 02 2018      	5       	3	5:3
August, 03 2018      	4              	2	2:1``````
D2=
Code:
``=B2/GCD(B2,C2)&":"&C2/GCD(B2,C2)``

#### jtakw

##### Well-known Member
Hi,

Now if you want a specific ratio, like "how many washes per unit of detergent" or vice versa, then:

#### mark692

##### Active Member
thanks guys, i want to know if the number of detergent is getting lower than the number of wash everyday, do you think by knowing the ratio will help me?

#### jtakw

##### Well-known Member
thanks guys, i want to know if the number of detergent is getting lower than the number of wash everyday, do you think by knowing the ratio will help me?
Column E in my sample is telling you it's getting lower.

Edit: So to clarify, as you can see in Column E, we started with 0.67 unit of detergent per wash, then 0.6, then 0.5

Last edited:

#### mark692

##### Active Member
Column E in my sample is telling you it's getting lower.

Edit: So to clarify, as you can see in Column E, we started with 0.67 unit of detergent per wash, then 0.6, then 0.5
i see i get it now sir thanks so much!

#### jtakw

##### Well-known Member
You're welcome.

Looking at your question in Post #4 again, I'm not so sure I understood correctly.

So the downward trend in Column E Only means people are using Less detergent per wash, it doesn't mean that your business is going "downhill", see additional sample (August 4) below: