• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate % change against a range of cells [SOLVED]

AlexH

New Member
Like busses these questions. I had a look in the tutorials but am a little stuck.


I need to do a calulation that calculates the % mass loss of a material over time. The sheet looks something like this.


Cell A1 - Start mass

Cell B1 - Mass after 1 hour

Cell C1 - mass after 2 hours etc

etc


Cell F1 - % change of the last reading (once it reaches a point I'll stop measuring)


So the range is dynamic and I'm not sure which function to use. I'd like to be a bit clever and not do it by using a calulator as there are potentially a load of rows.


Hope it makes sense...Alex
 

keymaster

New Member
hmm.. I am not sure I got it right.. but here is how you can attack it...


total mass loss % = 1- end mass/start mass


thus in cell F1 you can try something like this = 1 - index(a1:e1,count(a1:e1))/a1
 
Top