Calculating Ratio

akhlaq768 · #1 (**permalink**) 01-09-08, 07:39

I have two fields with data in it,

for example -

Field 1:
2068
4567
5421
5442
2135

Field 2:
102
212
855
218
544

What is the formula to work out a rato from the two fields?

thanks in advance

michaeldavid · #2 (**permalink**) 01-09-08, 07:57

are you after field 1 divided by field 2.

then the answer is 1: the number calculated

Hope this is the answer??

gvee · #3 (**permalink**) 01-09-08, 08:08

I think you're almost there, but I bet the OP doesn't want

1:1.25

Instead they want

4:5

(whole numbers only)

Is this right matey?

akhlaq768 · #4 (**permalink**) 01-09-08, 09:36

both of you are really right,

thanks

how do i add the calculated cell into a Pivot Chart?

Internet Services

Web Development

Digital Marketing

Consumer Tech