Numbers for iMac divide a formula in a cell

  bigt55 19:10 07 Mar 2017
Locked

Hi I have created a formula in a cell and what to divide it by 100 to give me an answer in £s. The formula I have used in cell A7 (entries are in pence) is =(A1A5)-(A1A2) which returns me the answer I want in A7 but in pence is there something I can add to the formula I have to convert it to pounds. i.e. divide by 100. I have tried adding (/100) with and without brackets.

  hastelloy 08:44 08 Mar 2017

Your formula would need to be =((A1A5)-(A1A2))/100 or =((A1A5)-(A1A2))*0.01

  bigt55 11:27 08 Mar 2017

Thanks, hastelloy that worked a treat

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

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?