Creating a formula for numbers for percentages

I have in column E a column of prices. I want to create in column F those prices less a percentage of 43.5%.

Struggling here! Any help gratefully received. I'm using MacBook Air

Posted on Jun 6, 2020 3:55 AM

⚠️

Top-ranking reply

Yellowbox

Level 7

21,551 points

Posted on Jun 6, 2020 7:19 AM

Hi KCSCES,

One approach:

Formula in F2 (and fill down) =E2−E2×43.5%

Regards,

Ian.

View in context

Similar questions

How to make a percentage discount column in Apple Mac Numbers Help with formula How to make a percentage discount column in Apple Mac Numbers I Want Column D to be the result of: Column C x .90 ( so Column D will be column C times .90 , or a 10% price reduction) I want this to apply to rows 2 thru 79 How to do this? Thanks
5 years ago 2564 2
How to add 10% to a whole column in numbers i have a cafe and will be increasing my prices by 10% how can i add a formula to populate on all of of items in the spreadsheet
2 years ago 1296 3
Percentages/Numbers Hi, I'd like to insert a formula in numbers to calculate a value as a percentage of a value. e.g I'd like a row to to display 20% of another row. Any advice please. Thank you! Nigel
4 years ago 277 1

2 replies

Sort By:

⚠️

Top-ranking reply

Yellowbox

Level 7

21,551 points

Jun 6, 2020 7:19 AM in response to KCSCES

Hi KCSCES,

One approach:

Formula in F2 (and fill down) =E2−E2×43.5%

Regards,

Ian.

KCSCES Author

Level 1

4 points

Jun 6, 2020 7:31 AM in response to KCSCES

Many thanks Ian

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Creating a formula for numbers for percentages

Quick Links

Creating a formula for numbers for percentages

Similar questions