# Can't think right now....

#### andremayer

##### Board Regular
Hi there,

I'm probably gonna beat myself up after I get the answer, because I know it's simple, but if someone can please let me know what's the exact formula for:

Let's say I made \$1000 yesterday and made \$1100 today. I know I"m up 10% from the day before. What's the formula to determine how much % I made either + or - the minus part is what I'm having trouble with. Example, yesterday I made \$1000 and today I made \$900, I"m down 10%, but how can I have a -10% or even plus for that matter.

Sorry for the stupid question, but it would really help me right now.

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

#### VoG

##### Legend
Does this help?

<b>Sheet6</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Yesterday</td><td >Today</td><td >% change</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">1000</td><td style="text-align:right; ">1100</td><td style="text-align:right; ">10</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">1000</td><td style="text-align:right; ">900</td><td style="text-align:right; ">-10</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C2</td><td >=100*(B2-A2)/A2</td></tr><tr><td >C3</td><td >=100*(B3-A3)/A3</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

Replies
3
Views
202
Replies
23
Views
760
Replies
7
Views
707
Replies
3
Views
904
Replies
6
Views
768

1,190,767
Messages
5,982,822
Members
439,799
Latest member
matts12

### 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.

### Which adblocker are you using?

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

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