Numbers for iMac divide a formula in a cell

  bigt55 19:10 07 Mar 17

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 17

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

  bigt55 11:27 08 Mar 17

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


Samsung Galaxy S8 review

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

What’s happening in VR right now: From psychedelic art to combat therapy

Siri not working? Try these troubleshooting fixes