You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

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
Question marked as Top-ranking reply

Posted on Jun 6, 2020 7:19 AM

Hi KCSCES,


One approach:


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


Regards,

Ian.

2 replies

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 Account.