Apple Event: May 7th at 7 am PT

> Add to your calendar

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

4 points

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

Reply

Best reply

Level 7

20,383 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

2 replies

Best reply

Level 7

20,383 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.

Reply

Level 1

4 points

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

Many thanks Ian

Reply

Creating a formula for numbers for percentages

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple ID.

Learn more Sign up