I need excel to calculate a simple formula (=(B8-C8)/C8) to give me 5.5%
and not just 5%. How can I do this?
I need excel to calculate a simple formula (=(B8-C8)/C8) to give me 5.5%
and not just 5%. How can I do this?
I guess it depends on what's in B8 and C8
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
"helpmeplease" <[email protected]> wrote in message
news:[email protected]...
>I need excel to calculate a simple formula (=(B8-C8)/C8) to give me 5.5%
> and not just 5%. How can I do this?
Format the cell. Right click on the cell, choose Format Cells..., go to the
Number tab, and specify the number of decimal places.
--
Regards,
Fred
"helpmeplease" <[email protected]> wrote in message
news:[email protected]...
>I need excel to calculate a simple formula (=(B8-C8)/C8) to give me 5.5%
> and not just 5%. How can I do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks