How To Use Percent In Mac Numbers 

Gary’s math game is good, learnt a few new tricks there beyond just using Numbers 👌

For the past 15 years I have used paper, pen and a calculator to do percentage of discounts then put it on a sheet. Months of my life would have been saved had I only knew just this one thing. Thank you.

Thank you, Gary! Math was never my strong suit, but this video will help. ❤️👍🏻

Super helpful and straight to the point. Thank you!

Very good video Gary as usual. You are my go to when it comes to anything apple related 👍

Dude you're a mac godsend and genius with your easy explanations. it really shows how easy Mac programs can be.

Yet ANOTHER AWESOME vide teaching!!!!

Gary + these tutorials = LEGEND

I’m learning so much from you!!

This is really cool. I am new to running Numbers and am trying to put together a bell curve and histogram for analytical data.

Thank you!

Thanks Gary worked out great. Cheers

Beautiful- thanks for the fruit example!!!

Another informative video Gary ;)

I love your channel!

Efirst time I understood please make more excell / numbers

The Bob Ross of Mac learning

Thank you

Awesome!

Thanks sir

Thank you so very much for your constant creation of these video tutorials, they are for sure improving the world! Would it be posible to submit a tutorial request on Numbers? .. I've been searching on how to work around the 15 limit conditional highlight on a cell without using the 2nd table with no fill overlap trick

I will give you 💯for this video👍

Any way to add In a date in the same cell as a number amount $ so I can track the date of a payment from a customer.? Or some other way to do this if the customer makes up to 8 different payments to track it?

hey how do get your pointer to do that cool pinging effect. good vids thanks

hey gary, do u create full tutorial for Numbers, Keynote ? i really want work with these software instead of microsoft office

Gary, excellent tutorial. Very helpful. While you are in Numbers would you consider doing a lesson on vlookup?

Great Videos. I am writing from Quito-Ecuador. I have a problem trying to make the universal clipboard work to share information between my iPhone 8plus an my MacBook Pro 2020 13 inches, an also using my iPhone camera to scan documents or take pictures for "pages" (both devices are upgraded to the latest version of OS, both devices are suscribe to the same iCloud account, and also to the same wifi ). It is getting me nuts!! .Please advise and thankyou. (

Hey Gary! Just a tip... Not particularly for this video, but for future reference, would it be great if you timestamp your recommendations. Makes it easy to scrub for efficiency purposes. Thanks!

Hi - what if I need a total OF a percetage? For example I need to add 15% of my total sum as a management fee. So I have a Total Number, for eg 10,000 and I need to calculate 15% of this total.

I'm looking at adding markers to my Numbers sheet. I would like the background color to change to orange between 10% - 20% and above 20% red. Do you have tips on achieving this?

Thanks a lot for sharing your knowledge with us! I'd be great if you could give tip on how to ad percent to a value in the column, but it is needed to add 10 percents to each cell to whole column without creating another column, so there is only one column in the table with numbers... Could you please help? Thank you in advance!

For a business that collects sales tax on purchases, I am in search of a rounding formula similar to my Canon Calculator rounding feature. The Canon calculator has a round-up, round-off or round-down feature. Example, I have a purchase ticket of $37.00 in which my Canon calculator rounds up tax $3.06 at tax rate 8.25%. However, in my Apple Numbers tax column the tax amount shows as $3.05 tax on purchase of $37.00. Essentially Numbers reads the tax as $3.053. How can I round up $3.053 to $3.06 regardless of the third decimal number? I use a custom formula to determine taxable and non-taxable purchases..."Y" for sales tax or "N" for exempt. Current Formula from a specific cell in sales tax column IF(G18="Y",F18×8.25%) [G18 is yes for taxable, F18 is purchase amount $37.00 times tax rate 8.25%]. Thanks!

It’s bugs me every time when you hit the =, the function box overlays your text/cell that you’re working in.

What about creating playlists in Music app?

ok, I do have a question but first thanks so much for the explanation, but here you go my question I'm trying to do a spreadsheet, and it goes like this $945.00 + formula as you explained(in this case I'm trying to do it with 1%), my result is $945 but how can make it to give the amount as $9.45. thank you n advanced.

Hi Gary I do a shopping spread-sheet and how do you get the average to change automatically every month

Sir how to calculate the percentage of age? for example: a 35 year old person lived 9 years in a certain area, so how much percentage of life he spent in that area?

Hi, can you show how you link a cell in numbers to a sheet in pages please?

Hi your channel is great, I am making a spreadsheet for my freelance work and require a column that deducts 20% from my earnings column A1 with £100.00 and in B1 I want to A1-20% which should leave me with £80 But it’s not working, would be great and a real help if you can point me in the right direction

trying to make my sum -20% and another block to have the sum of the 80% to show in another box

Told me everything but what I actually needed. Add two columns and then multiply by 10%. When I do the =sum(B3+D3*10%) the math is wrong.

How to convert numbers in to words.example : 115-> one hundred fifteen ……. In mac numbers app

Is there a way to calculate transaction fee 3%+$0.25? I cannot for the life of me figure this out

Blablablabla. The answer you're looking for is at 2:27. Skip the rest.

I hate math