Excel Formula

  Ritchbee 10:33 16 Apr 2008


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


  VoG II 10:45 16 Apr 2008

Format the result cell as Fraction.

  Ritchbee 15:33 16 Apr 2008


Any chance of providing me with an example?.


  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.

Appreciate your help with 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


  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

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique