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.

📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025

Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >

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.