
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: 412
Member Since:
December 20, 2019
December 20, 2019

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Genevieve Guex, Richard Benson-King, Janset Beyaz
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
wahab tunde
Cong Le Duc
Faisal Bashir
Ivica Cvetkovski
Blaine Cox
Shankar Srinivasan
riyepa fdgf
Hannah Cave
Len Matthews
Kristine Arthy
Forum Stats:
Groups: 3
Forums: 24
Topics: 6205
Posts: 27209
Member Stats:
Guest Posters: 49
Members: 31878
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
