From: LowRider on 8 Mar 2010 02:23 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 From: Joe User on 8 Mar 2010 02:36 "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  |  Pages: 1 Prev: Missing alphanumeric number in the sequenceNext: Merging Columns