If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Percentage Help
Hi All,
I am trying to figure out how to get a percentage to show up in certain cells. THis is what I have: C D E F G List Price Retail Price Wholesale Sponsor1 Sponsor2 20.00 49.95 =8%*D2 =7%*D2 =6%*D2 SHOWS AS 4.00 WANT 45.95 Ok the formula =8%*D2 shows the discount amount of 3.996 but what I want to do is show the actual cost. So if I subtract 8% from 49.95 the discount would be 3.996 so in E I would want the Cell to show 45.954 which reflects the discount. Same goes for F and G. Your help would be greatly appreciated. Thanks much in advance |
#2
|
|||
|
|||
Percentage Help
"LowRider" wrote:
so in E I would want the Cell to show 45.954 which reflects the discount. Ostensibly, you want: =D2*(1-8%) ----- original message ----- "LowRider" wrote: Hi All, I am trying to figure out how to get a percentage to show up in certain cells. THis is what I have: C D E F G List Price Retail Price Wholesale Sponsor1 Sponsor2 20.00 49.95 =8%*D2 =7%*D2 =6%*D2 SHOWS AS 4.00 WANT 45.95 Ok the formula =8%*D2 shows the discount amount of 3.996 but what I want to do is show the actual cost. So if I subtract 8% from 49.95 the discount would be 3.996 so in E I would want the Cell to show 45.954 which reflects the discount. Same goes for F and G. Your help would be greatly appreciated. Thanks much in advance |
Thread Tools | |
Display Modes | |
|
|