Excel Formula

  Ritchbee 10:33 16 Apr 08
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 08

Format the result cell as Fraction.

  Ritchbee 15:33 16 Apr 08

VOG

Any chance of providing me with an example?.

Cheers
Brian

  VoG II 15:38 16 Apr 08

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 08

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 08

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 08

Thanks once again VOG for your help and assistance

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

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

1995-2015: How technology has changed the world in 20 years

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's best models…

CarPlay tips & troubleshooting guide: CarPlay tips & troubleshooting guide: Get the most from…