Thread Tools Display Modes
Old 06-05-2001, 11:40 AM
Join Date: Oct 2000
Posts: 371
I am trying to find the formula to calculate the savings erned between two values.

Cost of Item 1 = 1400
Cost of Item 2 = 1600
Q: What percent is saved when buying I1 over I2?

I1/I2=% so 1400/1600 = .87 Or 87%

Now...100-87 = 13.

That "13" should be the savings percentage no? But I can't figure out how to get Excel to calculate that in a formula. Any ideas???? (I have a feeling this is so simple and I'm gonna smack myself in the head when I see it...)
Old 06-05-2001, 11:47 AM
Join Date: Jun 2000
Posts: 1,394
1 - I1/I2
Old 06-05-2001, 11:49 AM
zut zut is offline
Charter Member
Join Date: Apr 2000
Location: Detroit, MI
Posts: 3,725
Do you mean:

Savings Percentage = (I2 - I1)/I2

Or, in your example, the money you save is $1600-$1400 = $200, and the original cost is $1600, so the savings percentage = ($1600-$1400)/$1600 = 12.5%
Glaring directly down towards her was the stoney, cycloptic face of the bloated diety. Gaping from its single obling socket was scintillating, many fauceted scarlet emerald, a brilliant gem seeming to possess a life all of its own. A priceless gleaming stone, capable of domineering the wealth of conquering empires...the eye of Argon.
Old 06-05-2001, 12:06 PM
Join Date: Oct 2000
Posts: 371
Originally posted by Tretiak
1 - I1/I2
Perfect! Thanks dude! It worked!

I was using: =(D3/G3)-1

Apart from the obvious, D3 and G3 were in the wrong order.
See? I told you I'd be smacking myself in the head...

Zut: Yep. That's what I was looking for.

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

All times are GMT -5. The time now is 07:49 AM.

Copyright © 2017
Best Topics: doctor prestige smelly potatoes shaggy dog story feather duster syndrome desmond dekker israelites triangle bayonet yellow tinted windows black belt register boy hardons sunken city movie hay bale cost unwashed masses smoke and oakum outside couch famous trio waterboarding techniques does valium expire eskimo song smells behind ears nadia vs atlantis my ruthschris dracula vs superman scandal message board imodium expiration sand in latin steam program files damian lewis mouth rockford turn 814 credit score truffles taste certified business location paper carrier are seagulls edible winged penis meaning of candles in windows rainbow vacuum and air purifier best version of axis and allies electric to propane conversion fedex package in transit for a week can you recoat a non stick pan elephants name in tarzan why would someone steal my car registration 5'7 compared to 6'0 hepatitis a blood donation cell block tango hungarian how to play scribbage 19mm spark plug socket salvation army booth memorial hospital chicago where is the steam directory what is safe pass bank of america difference between farsi and dari does ben affleck wear a hairpiece what is sweater weather adam and eve shipping how to make canned mixed vegetables taste good sex shop washington dc what is lemonade and vodka called throwing trash on the ground are bob ross paintings worth money untucked shirt and tie white spots inside sweet potato average walking heart rate dell studio 1555 battery not charging can you use euro in london biggest bitch in hollywood fat girl tattoo placement what does 41 mean dead like me theme song