Excel Experts! I need help

[axelfox]

Ok, I'm doing a balance statement, but the numbers aren't coming out right.

Basically (with a few exceptions) all aspects should increase by 21% from 1991 to 1992. So, Cash SHOULD rise from $205,100 to 248,171 (205,100*1.21). However, when I have excel do it, it comes up with 247,829.

This is what i have in the cells:
B11=21%
F15=205,100 (1991)
G15= ? (1992) (comes out 248,829, should be 247,171)
In G15, I put: =F15*(1+B11), but it doesn't come up right.

Sorry if thats vague...
Am I doing something wrong?

 

[konichiwa]

<< Cash SHOULD rise from $205,100... >>

<< F15= 210,100 (1991) >>

 

[axelfox]

Fixed that part..

 

[konichiwa]

Oh, so that was a mistype, not what you really have in the cell?

 

[axelfox]

Yeah, it should all be right.

 

[OhioDude]

Huh?????

When I do this in Excel, I come up with 248,171...

 

[josphstalinator]

i get the right answer too

 

[axelfox]

What the heck is going on...

 

[yata]

Bush' macro virus.

 

[yata]

Seriously, try switching the cells.

 

[axelfox]

Still nothing..

 

[kranky]

Is the 21% entered in B11 computed from other cells, or did you enter the &quot;21%&quot; directly? If it's computed, maybe it's being rounded for display purposes and isn't EXACTLY 21%.

 

[joohang]

I got the right answer too.

Is your &quot;21%&quot; cell formatted to be a percentage cell?

 

[axelfox]

Yeah, the 21% is computed from other cells. I was thinking that.

Anyways, I just manually entered .21, but I wondered what really went wrong.