Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Help with Spreadsheet (math question)

Thread Tools
 
Search this Thread
 
Old 22 November 2005, 10:12 AM
  #1  
boxst
Scooby Regular
Thread Starter
 
boxst's Avatar
 
Join Date: Nov 1998
Posts: 11,905
Likes: 0
Received 0 Likes on 0 Posts
Default Help with Spreadsheet (math question)

Hello

I'm just not awake this morning, so asking for help. Feel free to call me stupid (and provide the answer!).

I have two numbers x and y, I want to know the percent increase of x to get to y.

i.e.

10 15 50% increase
12 15 25% increase

What is the formula?

Thanks!

Steve
Old 22 November 2005, 10:21 AM
  #2  
boxst
Scooby Regular
Thread Starter
 
boxst's Avatar
 
Join Date: Nov 1998
Posts: 11,905
Likes: 0
Received 0 Likes on 0 Posts
Default

Hello

For completeness incase anyone else is feeling stupid in the mornings:

=(B2-A2)/ABS(A2)

STeve
Old 22 November 2005, 12:15 PM
  #3  
Dracoro
Scooby Regular
 
Dracoro's Avatar
 
Join Date: Sep 2001
Location: A powerslide near you
Posts: 10,261
Likes: 0
Received 0 Likes on 0 Posts
Default

If a1 = 10 and b1 = 15

(b1 / a1) - 1

easy.

and a1/b1 to get the other way round (i.e 10 is n% of 15)
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
KAS35RSTI
Subaru
27
04 November 2021 07:12 PM
slimwiltaz
General Technical
20
09 October 2015 07:40 PM
IanG1983
Wheels, Tyres & Brakes
2
06 October 2015 03:08 PM
Brzoza
Engine Management and ECU Remapping
1
02 October 2015 05:26 PM
the shreksta
Other Marques
26
01 October 2015 02:30 PM



Quick Reply: Help with Spreadsheet (math question)



All times are GMT +1. The time now is 12:55 PM.