Help with Exponential Forumla

olismith89

New Member
Joined
Dec 4, 2014
Messages
12
Hi there,

I am trying to create an exponential formula but I can't wrap my head around it.

Essentially, I want to be able to enter X (see below) into cell A1 and have the result appear in A2.

Nerdy background for my problem - it's for a D&D game where characters will spend X amount of time within a separate dimension. With each hour they spend, the time in their home dimension advances exponentially.
1 hour inside = 1 hour outside
+1
2 hours inside = 2 hours outside
+2
3 hours inside = 4 hours outside
+3
4 hours inside = 7 hours outside
+4
5 hours inside = 11 hours outside
Etc.

Each hour, the time on the outside increases exponentially starting at +1, then +2, +3, +4 etc. So if they spent 8 hours inside, it would be 1+2+4+7+11+16+22+29 = 92 hours.

I want to be able to enter X as the amount of time they spent inside this dimension and have the formula work out the exponential and total it to show how much time has passed in their home dimension.

I'm ok at maths but not very good with exponentials so I can't even work out a real-world formula for my problem. Any maths wizards who know a thing or two about excel, please help!

Hopefully the example makes sense.
 

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
17,087
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
Maybe something like this...

Pasta2
AB
1Hours InsideResult
2892
337
4414
522
6525
711
8763
Plan1
Cell Formulas
RangeFormula
B2:B8B2=IF(A2=2,2,SUMPRODUCT((ROW(A$1:INDEX(A:A,A2))-1)*ROW(A$1:INDEX(A:A,A2))/2+1))


M.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Forum statistics

Threads
1,175,957
Messages
5,900,534
Members
434,835
Latest member
cmenconi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top