Help with TODAY formula

[steve swinehart]

I need help with my seldom used 45 year old algabra equations.

I want to produce the following:

=(((TODAY()+3455))*W38+L30)/(((TODAY()+3455)))

Where: W38 = 190
L30 = 1,322.648

I can't seem to get a correct answer when i compare it to my longhand calc.

Thanks in advance

 

[Ruddles]

That formula gives 190.03 here.

If you want us to check you have your brackets in the correct places - and you do appear to have a few superfluous ones - you'll need to walk us through your longhand working or at least tell us what answer you got.

 

[Jared_8878]

What for you is the "right answer"?

 

[Comfy]

=(((TODAY()+3455))*W38+L30)/(((TODAY()+3455)))

Multiplies Today by W38 and then adds L30. Is this what you are after?

or

=(((TODAY()+3455))*(W38+L30))/(((TODAY()+3455)))

Adds W38 and L30 then multiplies by Today

 

[T. Valko]

I need help with my seldom used 45 year old algabra equations.

I want to produce the following:

=(((TODAY()+3455))*W38+L30)/(((TODAY()+3455)))

Where: W38 = 190
L30 = 1,322.648

I can't seem to get a correct answer when i compare it to my longhand calc.

Thanks in advance

What result do you get and what result do you expect?

You have a bunch of parentheses in there. Could be just removing/rearranging them will correct the issue.

Where the parentheses are located controls how Excel calculates the equation.

A recent example:

http://www.mrexcel.com/forum/showthread.php?t=564819

 

[steve swinehart]

=(((TODAY()+3455))*W38+L30)/(((TODAY()+3455)))

Multiplies Today by W38 and then adds L30. Is this what you are after?

or

=(((TODAY()+3455))*(W38+L30))/(((TODAY()+3455)))

Adds W38 and L30 then multiplies by Today

The first is what I want.

I get 220 in my cell, and 227 below.
(40742+3455)*190+1322648/(40742+3455 = 227

 

[Comfy]

((40742+3455)*190+1322.648)/(40742+3455) = 190.0299262

Possibly?

are we to use 1322648 or 1322.648

 

[steve swinehart]

((40742+3455)*190+1322.648)/(40742+3455) = 190.0299262

Possibly?

are we to use 1322648 or 1322.648

sorry, 1,322,648

 

[Comfy]

3 separate examples

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">190</td><td style="text-align: right;;">1322648</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;font-style: italic;;">3504.576359</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;font-style: italic;;">3693.576359</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;font-style: italic;;">219.9261941</td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A3</th><td style="text-align:left">=(<font color="Blue">TODAY(<font color="Red"></font>)+3455*$A$1+$B$1</font>)/TODAY(<font color="Blue"></font>)+3455</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A4</th><td style="text-align:left">=(<font color="Blue">(<font color="Red">TODAY(<font color="Green"></font>)+3455</font>)*$A$1+$B$1</font>)/TODAY(<font color="Blue"></font>)+3455</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A5</th><td style="text-align:left">=(<font color="Blue">(<font color="Red">TODAY(<font color="Green"></font>)+3455</font>)*$A$1+$B$1</font>)/(<font color="Blue">TODAY(<font color="Red"></font>)+3455</font>)</td></tr></tbody></table></td></tr></table><br />

 

[steve swinehart]

3 separate examples

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right">190</TD><TD style="TEXT-ALIGN: right">1322648</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right; FONT-STYLE: italic">3504.576359</TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right; FONT-STYLE: italic">3693.576359</TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="TEXT-ALIGN: right; FONT-STYLE: italic">219.9261941</TD><TD style="TEXT-ALIGN: right"></TD></TR></TBODY></TABLE>

Sheet1​

<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>A3</TH><TD style="TEXT-ALIGN: left">=(TODAY()+3455*$A$1+$B$1)/TODAY()+3455</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>A4</TH><TD style="TEXT-ALIGN: left">=((TODAY()+3455)*$A$1+$B$1)/TODAY()+3455</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>A5</TH><TD style="TEXT-ALIGN: left">=((TODAY()+3455)*$A$1+$B$1)/(TODAY()+3455)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

ok, let's try this.

I have $1,322,648 in cash and investments. I receive $190.00 per day in interest and income. I want to know how much I can spend per day for 10 years before reaching $0.00 (without compounding interest).

Hope this helps