Can someone help me get my formula to answer to 2 decimal points. Im making changes to my invoices Ive created using Pages and want the totals to work out themselves. So far I have it answering correct but need to make the answer to 2 decimal points for a nicer look.
HELP ME PLEASE ive wasted so much time today.
Cheers
MacBook Pro, iOS 8.3
Change the cell format in the Format sidebar to "Currency".
Peter
Hi Mad Ad,
Peter's advice to use Currency format is good:
Format Panel > Cell > Data Format > Currency
Two further tips:
1. The PRODUCT function is not necessary. The formula can be simplified to =B2÷11
2. If you use a table with a Header Row (Row 1) and a Footer Row (Row 4 in your example) the formula in B4 can simply be =SUM(B). That is the SUM of all Body Rows (Rows 2 to 3).
That will allow you to add more Body Rows if you need them, and formulas in the Footer Row will automatically adjust.
Please call back with questions.
Regards,
Ian.
Pages Furmula Help
