How To Use Percent In Mac Numbers
Вставка
- Опубліковано 6 тра 2021
- macmost.com/e-2431 When using percentages in Mac Numbers, keep in mind that what you are using are really decimal fractions, and not the whole number shown as a percentage. Use formatting to properly show a value as a percent. Also learn how to use percents for sales tax and other things.
FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ UA-cam - macmost.com/j-youtube (And hit the 🔔)
▶︎ UA-cam Email Notifications - macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter - macmost.com/newsletter ✉️
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/patreon ❤️
#macmost #mactutorial #macnumbers - Наука та технологія
Very good video Gary as usual. You are my go to when it comes to anything apple related 👍
Gary’s math game is good, learnt a few new tricks there beyond just using Numbers 👌
Thank you, Gary! Math was never my strong suit, but this video will help. ❤️👍🏻
Super helpful and straight to the point. Thank you!
I’m learning so much from you!!
Yet ANOTHER AWESOME vide teaching!!!!
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.
Thanks Gary worked out great. Cheers
This is really cool. I am new to running Numbers and am trying to put together a bell curve and histogram for analytical data.
Another informative video Gary ;)
I love your channel!
Gary + these tutorials = LEGEND
Dude you're a mac godsend and genius with your easy explanations. it really shows how easy Mac programs can be.
Beautiful- thanks for the fruit example!!!
Thank you!
Thank you
Awesome!
Thanks sir
Efirst time I understood please make more excell / numbers
The Bob Ross of Mac learning
"We don't make mistakes, just happy little accidents."
I will give you 💯for this video👍
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 think if you have that many conditional highlight rules it is probably better to come up with another solution to the problem you are trying to solve. Hard to suggest something without knowing more. Maybe ask at macmost.com/ask with details.
@@macmost Thank you so very much, it's very kind of you!
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 gary, do u create full tutorial for Numbers, Keynote ? i really want work with these software instead of microsoft office
MacMost website offers full tutorials for cost.
hey how do get your pointer to do that cool pinging effect. good vids thanks
That is a feature in the screen recording and editing software I use, ScreenFlow.
Gary, excellent tutorial. Very helpful. While you are in Numbers would you consider doing a lesson on vlookup?
Here's one I did on LOOKUP. ua-cam.com/video/JMYHK5FZUjU/v-deo.html You can read the help in Numbers to see the difference. In most cases you want LOOKUP anyway.
@@macmost Thanks for the link. I needed a refresher. Super helpful.
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!
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. (
Sorry, not sure why it is not working for you. Call Apple Support and have them walk you through checking all of your settings, etc.
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!
With spreadsheets you have formulas in cells that take numbers from other cells and perform operations on them. You don't permanently change the values in a column. So you would create a second column, yes. In that column you would have the formula to do your calculation based on the numbers in the first column, like multiplying by 1.1 to "add 10 percent."
@@macmost THANK YOU SU MUCH FOR YOUR TIME! I WISH YOU LUCK IN YOUR WORK! YOU ARE DOING GREAT JOB!
@@macmost How does one add 10% to a whole column?
You would do that in the next column. So if the first column was B, then, in the next column, you would put things like =B2*1.1@@tonyvaf
It’s bugs me every time when you hit the =, the function box overlays your text/cell that you’re working in.
Drag the function box out of the way.
@@AlanGoldberg I’ve been dragging it for as long as I can remember. I wish it would just pop up one row about the entry cell.
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.
Not sure what you mean. Sounds like you just want to calculate the total, then multiply by 0.15, right?
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!
Use CELING with .01 as the factor parameter.
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.
Multiply 945 by .01.
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?
Not sure what you mean by "markers." You can use conditional highlighting to change the color of a cell based on its value. ua-cam.com/video/m5QkGYvfYRk/v-deo.html
@@macmost Hi, Markers as in red flags, points of interest. So when a value changes above 10% (till 20%) the cell turns orange and when the value in a cell changes above 20% it turns red.
@@us2travelmoments151 Yes, so that video I pointed to is the one you want.
@@macmost I've tried that option but Somehow it doesn't want to apply it to percentage cells (which are results of a sum)
@@us2travelmoments151 Are you remembering that percentages are really things like 0.2 (20%) and such? If you look for numbers greater than 20 it won't work. You have to look for greater than 0.2.
What about creating playlists in Music app?
ua-cam.com/video/2qfyt-grQPI/v-deo.html
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?
(9/35)100
@@tschmath Thanks
Hi Gary I do a shopping spread-sheet and how do you get the average to change automatically every month
Not sure what you mean by that.
Each month you get the total for that months shopping and now we are in May you divide by 5 next month it will be divide by 6 but you have to enter the formula manually @@macmost
@@supersonicsid So you have one row per month? Use the AVERAGE function. If you take the AVERAGE of all of the cells in a column and there are 5 rows, it will calculate it without needing to know what to divide by. Then when you add a new row, it recalculates.
@@macmost Hi Gary the spreadsheet is in 12 columns 5 rows (some months have 5 weeks) you get the total for each month which adds up to a final total then divide that by which month we are in the year but next month i will have to manually divide the figure by 6, thanks for taking a interest Sid.
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
20% is simply the number 0.2. So if you subtract that from 100 you get 99.8. You have to subtract 20 percent OF your amount, not the value 0.2. So A1-A1*20%. Watch the video for a better explanation.
@@macmost your a legend, thanks so much, you and your channel are very informative
Hi, can you show how you link a cell in numbers to a sheet in pages please?
You can't. There is no cross-document linking.
@@macmost thanks. can i add a hyperlink like microsoft?
@@infocpctrainer Yes. Select some text inside a cell. Then choose Format, Add Link.
@@macmost would be great if you could show, as i've tried and failed, thanks anyway if you're too busy?
@@infocpctrainer No easy way for me to do that for you here. What did you try? In what way did it "fail?" Adding a link in Pages, Numbers and Keynote is pretty straightforward.
trying to make my sum -20% and another block to have the sum of the 80% to show in another box
So either take the amount and subtract that amount times 20%, like =B2-B2*20%. Or, subtract 20% from 100% like =B2*(100%-20%). Or just use 80% like = B2*80%.
How to convert numbers in to words.example : 115-> one hundred fifteen ……. In mac numbers app
No good way to do that, sorry.
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.
First, the SUM function doesn't work like that. It sums a range, like SUM(B2:B9) to add up the cells from B2 to B9. If you just want to add two cells that aren't in a range, just add. So B3+D3. Then you have to watch your parenthesis and know basic order-of-operations. So multiplication comes before addition. So B3+D3*10% would multiple D3 by 10% and add B3. You want (B3+D3)*10% which would add the numbers first, then multiply the total by 10%.
Is there a way to calculate transaction fee 3%+$0.25? I cannot for the life of me figure this out
The math is just to multiply by 0.03 and add 0.25.
Blablablabla. The answer you're looking for is at 2:27. Skip the rest.
I hate math