From Leo's mailbag:
> From: A Computer User
> Sent: March 26, 2007
> To: Ask Leo!
> Subject: Excel Formula question
>
> Leo,
> Please help me. Years ago this formula to find the percent of
> difference worked just fine: =C47-E47)/E47*100. Today this formula
> gets me an error message. C47 and E47 are dollars. I am 77 and just
> need a simple answer as I am not a math whiz. I did try the Google
> Search. Thank you in advance.
Looks like a simple typo:
=C47-E47)/E47*100
should be
=(C47-E47)/E47*100
Note the "(" I added.
Good luck!
Thanks for asking,
Leo
Article 11304
| Category:
Microsoft Office
