Numbers for iMac divide a formula in a cell

  bigt55 19:10 07 Mar 2017

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

What is Markdown?

Markdown lets you add more formatting to your post. Simply type in your post and it will display as written.

If you wish to add bold or italic characters, add a hyperlink to another website, a heading or a horizontal line, simply use the relevent icons above the text input field.

A preview of your post will appear in the grey box below. If you make a change and you're not happy, simply press the back arrow icon to undo.

Post a Reply


Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?