Using Simple Formulas in Apple Pages

Learn how to quickly create Tables in an Invoice using Apple Pages. This quick tutorial shows you how to easily add Formulas to Table Cells in your Pages Documents.
Learn how to Sum and Multiply table cell values the same way you would in a spreadsheet application like Numbers or Excel.
This Apple Pages Tutorial is for beginners to the Pages application. Pages is Apple's free alternative to Microsoft Word.

[@shriidharkulkarni6648]

Excellent video. Never realized Apple pages also has formula function in it. very well explained. Thanks

[@apple-a-day]

Glad it was helpful! Thanks for watching!

[@danaejones9074]

People like you make my life SO MUCH BETTER! Thank you!! I can do all of this with ease in microsoft word but had no idea how to use pages. Thank you, thank you!

[@apple-a-day]

Thanks so much for the kind words - glad I could help! Thanks for watching!

[@TerryWehr1986]

This is amazing. I've been doing this all wrong by using excel. When all I needed was pages.

[@apple-a-day]

Thanks! Glad it was useful!

[@danielquinton84]

Awesome! Thank you! no fuss video. simple instructions. easy to follow!

[@apple-a-day]

Glad it helped! Thanks for watching!

[@AustinRealtorJudy]

This is awesome! Thank you so much! I learned something new in a few minutes!

[@apple-a-day]

Glad it was helpful! Thanks for watching!

[@joshiroloop]

Thanks for the information John really helpful

[@apple-a-day]

Thank you! So glad it was useful to you. Thanks for watching!

[@trevsmith5825]

Excellent video, thank you.

[@apple-a-day]

Glad you liked it! Thanks for watching!

[@MaxPowers1245]

Great tutorial thanks

[@apple-a-day]

Thank you! And thanks for watching!

[@Anotaren]

Thanks!

[@apple-a-day]

No problem! Thanks for watching!

[@rycoryco2888]

Helpful. Thank you. What is the procedure to get both the title row and header row to repeat? It seems that only the header row will repeat?

[@apple-a-day]

HI there, thanks for your question however I'm not sure I follow what you mean. If you want to send me an email with more details, I'd be happy to take a look. Thanks!

[@arafatbage7945]

I tried using the = sign on my iPad pages and nothing came up

[@apple-a-day]

Unfortunately I don’t think you can create formulas in tables in Pages on the iPad. I couldn’t find any way to do it.

[@kmalih]

Yup i’ve faced the same issue with the ipad, unfortunately apple support won’t consider this anytime soon

[@harrylime22]

very useful thanks, how do I save the table for my next job please?

[@apple-a-day]

Thank you, glad it was helpful. There's no way to just save just the table, but you can do a couple of things to make re-using the table a little easier. You can always just copy the table from your Pages document and paste it into a new Pages document. Or you can save the pages document as a Template (near the bottom of the File Menu) and start all new documents from that template. Good luck and thanks for watching!

[@albertjohnhugo]

Is this function still working? I just downloaded the latest pages app and the "=" function are no longer working.

[@apple-a-day]

Hi there. I just updated my Pages to test this and it's working for me. I added a new table, selected a cell, pressed '=' and the formula editor appeared. If the '=' is not working for you you can always add it from the menu... in the menu bar, go to:
Insert -> Formula -> New Formula

[@tarheeljim]

Unless I am missing something, this does not seem to work when using Pages on an iPad. I can’t get it to work when I try to enter a formula in a cell in the table.

[@apple-a-day]

Hi there. You are correct... this feature does not seem to be available on the iPad version of Pages.

[@tarheeljim]

@@apple-a-day Thanks for the response. Hopefully Apple will add this to the iPad in the near future.

[@BethanyKateRowlands]

What's the formula to update the invoice number every time you make a new one. For example yours says AD0003, how do you have it automatically update to AD0004 next time ? Thanks

[@apple-a-day]

Hi there! This is a great question but unfortunately I don't think there is a way to do this in Numbers. If I ever discover a method for this I'll let you know. Thanks for the question and thanks for watching!

[@douglasprice5049]

@@apple-a-day if you name the file "invoice 01" then duplicate it, it will cerate a new file called "invoice 02" but inside the file it will not alter the number, but at least it changes the files name automatically to keep you reminded.

[@SY-mn6qb]

Just use field option of file name and name your files accordingly

[@HelloHello-ln9nx]

thank you!
anw, how to merge cells in pages? thank you beforehand

[@apple-a-day]

Hi there! You can merge cells if you select the cells you want to merge and then right click. From the Drop Down menu select 'Merge Cells'. That's all there is to it! Thanks for the question and thanks for watching!

[@adco]

👍🏆

[@apple-a-day]

Thanks for watching!

[@SY-mn6qb]

Item 1 can be dragged to be 2,3,4

[@apple-a-day]

Thanks!

[@Kavkaz_London2023]

1:39 I can’t understand how you did that

[@apple-a-day]

Hello, if typing in '=' is not working for you to bring up the formula editor, you can use the insert menu on the top of the window and select New Formula. That will do the same thing. Note that when you type in '=' you can't already be editing the contents of the cell, the cell should just be selected only. Hope this helps! Thanks for watching!

[@harleyhorton6349]

Is this possible on an iPad?

[@apple-a-day]

I assumed you could but I went to try it and couldn’t find a way to create a formula. Nor could I find it in any searches I did. It would seem that formulas can’t be created on the iPad in Pages Tables.

[@harleyhorton6349]

@@apple-a-day thanks for the reply mate been trying to work it out for ages. appreciate you looking into it!!!

[@AnimalLoversG]

Hello sir
how to create
th-cam.com/video/c5Vj6g3cMDg/w-d-xo.html
Thit type effects in Apple motion plz sir

[@apple-a-day]

I think something like that would be really difficult to do in Motion.

[@aZnLy96]

Thanks!

[@apple-a-day]

Thanks for watching!