How To Use Percent In Mac Numbers
Вставка
- Опубліковано 12 лис 2024
- macmost.com/e-... 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-y... (And hit the 🔔)
▶︎ UA-cam Email Notifications - macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter - macmost.com/ne... ✉️
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/pa... ❤️
#macmost #mactutorial #macnumbers
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.
Gary’s math game is good, learnt a few new tricks there beyond just using Numbers 👌
Dude you're a mac godsend and genius with your easy explanations. it really shows how easy Mac programs can be.
Thank you, Gary! Math was never my strong suit, but this video will help. ❤️👍🏻
Thanks, Gary, I hardly use Numbers or the alternate, Excel but this gave me the info I needed to set up a score list for some students (I work in a Primary School)
Yet ANOTHER AWESOME vide teaching!!!!
Very good video Gary as usual. You are my go to when it comes to anything apple related 👍
I’m learning so much from you!!
Beautiful- thanks for the fruit example!!!
This is really cool. I am new to running Numbers and am trying to put together a bell curve and histogram for analytical data.
Super helpful and straight to the point. Thank you!
Efirst time I understood please make more excell / numbers
Thanks Gary worked out great. Cheers
Another informative video Gary ;)
Thank you!
Gary + these tutorials = LEGEND
The Bob Ross of Mac learning
"We don't make mistakes, just happy little accidents."
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.
I love your channel!
I will give you 💯for this video👍
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.
Awesome!
Thanks sir
Thank 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 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.
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?
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
Hey I’ve been watching your videos looking to basically create a win loss chart/table that’s contains wins and losses and what the percentage would be it helps but i think im having an issue with out the information I laid out im rusty and definitely need some help is there a way i can reach out to you?
Sorry, I don't do consulting or anything like that if that is what you mean.
@@macmost I might not be using the correct terms it really like a simple table just to track my win/loss ratio and just add the percentage to it as well
@@Goldenstatic-uo7tm Percentage is just adding and dividing. So use a formula to sum your wins, and another to sum your losses, and then the win percentage is just wins / (wins + losses). Though you need to multiply by 100 also, since 100% = 1.0.
@ I appreciate you man I’ll definitely get to that when I go on break
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.
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.
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.
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.
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!
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 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.
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
What about creating playlists in Music app?
ua-cam.com/video/2qfyt-grQPI/v-deo.html
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.
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.
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
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%.
Blablablabla. The answer you're looking for is at 2:27. Skip the rest.
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.
How to convert numbers in to words.example : 115-> one hundred fifteen ……. In mac numbers app
No good way to do that, sorry.
I hate math