Excel Formula

Ritchbee 10:33 16 Apr 2008
Locked

Hi,

Anyone know if its possible in excel to do a calculation that come out as 8 and one third rather than say 8.33%.

Cheers
Brian

VoG II 10:45 16 Apr 2008

Format the result cell as Fraction.

Ritchbee 15:33 16 Apr 2008

VOG

Any chance of providing me with an example?.

Cheers
Brian

VoG II 15:38 16 Apr 2008

In A1 enter 25

In B1 enter 3

In C1 enter =A1/B1

The result will be displayed as 8.3333

Click in C1, Format > Cells and click Fraction.

Ritchbee 16:02 18 Apr 2008

Many thanks VOG

If I now wanted to take say a figure of 50K and divide it by 12 then multiply it buy the 8 1/3 to find a monthly amount how would you go about this.

VoG II 16:28 18 Apr 2008

Assuming that the 8 1/3 is meant to be a percentage, with the same numbers in A1, B1 and C1 and 50000 in D1 then in E1

=D1*C1/(100*12)

Ritchbee 12:24 21 Apr 2008

Thanks once again VOG for your help and assistance

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys