
Valerie Harlan
Active Member
Members

Forum Posts: 5
Member Since:
July 12, 2019
July 12, 2019

Hi. Im trying to make a document which calculates the percentage totals by allowing the user to enter any percentage into cell C23 (5%, 10%, 12%) and return the difference in cell D23. For example, B23 is the sum of B8 & B9. Based on customer ranking, they are entitled to receive 5%, 10%, or 12% back in "store dollars". I'd like for our internal users to be able to plug in the percentage for the specific customer in to cell C23 and excel will calculate the correct amount and return it to cell D23.
For the example shown on the attached, im looking for 5% of $107.00 ($5.35) to return in cell D23. How can i accomplish this?

Purfleet
England
Member
Members

Trusted Members

Trusted Members

Forum Posts: 414
Member Since:
December 20, 2019
December 20, 2019

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Mynda Treacy, Steven Grigsby, Srikanth Amudhan
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Forum Stats:
Groups: 3
Forums: 24
Topics: 6544
Posts: 28650
Member Stats:
Guest Posters: 49
Members: 32831
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
