Posted to microsoft.public.excel.misc

Gabriel

external usenet poster

Posts: 8

percentage calculation

Hi there, can somebody help me out with a simple formula I cannot get the
hang of?

A1=76,96%
A2=(1-A1)*29.000.000. Then I set the cell as number and the outcome is
66830090 while I need to obtain 6681600. How can I set the cell so to obtain
this value?
Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
'of' percentage with calculation (attempt 2)	Steve Crowther	Excel Discussion (Misc queries)	4	May 22nd 06 12:58 PM
How to place parenthesis around a negative percentage calculation.	Kay	Excel Worksheet Functions	1	February 3rd 06 07:52 PM
Percentage calculation	Roz	Excel Discussion (Misc queries)	5	January 6th 06 07:05 PM
Percentage calculation on text columns	Connor	Excel Discussion (Misc queries)	3	October 10th 05 04:22 PM
Percentage Calculation	clandis	Excel Worksheet Functions	5	July 21st 05 07:38 PM

All times are GMT +1. The time now is 08:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us