I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to 2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value in
cell A?
Sorry for the long explanation and thank you for any help.

Perhaps this in cell B:-

=ROUND(CellA,1)*CellC

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Jay" wrote in message
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to 2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value in
cell A?
Sorry for the long explanation and thank you for any help.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004

Hi
try the following formula for B1
=ROUND(A1,0)*C

--
Regards
Frank Kabel
Frankfurt, Germany
"Jay" schrieb im Newsbeitrag
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to 2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value in
cell A?
Sorry for the long explanation and thank you for any help.

Hi Jay,

Is this what you mean

=ROUND(A1,0)*C1

and form at as you want

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jay" wrote in message
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to 2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value in
cell A?
Sorry for the long explanation and thank you for any help.

Hi Frank - Don't forget the value being rounded is a percentage - Might need at
least one of those places :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Frank Kabel" wrote in message
...
Hi
try the following formula for B1
=ROUND(A1,0)*C

--
Regards
Frank Kabel
Frankfurt, Germany
"Jay" schrieb im Newsbeitrag
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to 2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value in
cell A?
Sorry for the long explanation and thank you for any help.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004

Hi Bob - Ditto reply to Frank :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Bob Phillips" wrote in message
...
Hi Jay,

Is this what you mean

=ROUND(A1,0)*C1

and form at as you want

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jay" wrote in message
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to 2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value in
cell A?
Sorry for the long explanation and thank you for any help.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004

Hi Ken,

You are right, but by that criteria should it not be 2 dec places?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ken Wright" wrote in message
...
Hi Bob - Ditto reply to Frank :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Bob Phillips" wrote in message
...
Hi Jay,

Is this what you mean

=ROUND(A1,0)*C1

and form at as you want

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jay" wrote in message
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to 2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value in
cell A?
Sorry for the long explanation and thank you for any help.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004

rotflmao - Oh S%&t :-) I tried it with 1 and it gave me what I wanted, then
hit the damn button <grrrr & touche :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Bob Phillips" wrote in message
...
Hi Ken,

You are right, but by that criteria should it not be 2 dec places?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ken Wright" wrote in message
...
Hi Bob - Ditto reply to Frank :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Bob Phillips" wrote in message
...
Hi Jay,

Is this what you mean

=ROUND(A1,0)*C1

and form at as you want

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jay" wrote in message
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to 2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value in
cell A?
Sorry for the long explanation and thank you for any help.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 04/03/2004

Ken and Bob, thank you. This is what actually solved it
after your helpful suggestions Cell D =ROUND(Cell A,2)
Cell B = Cell C * Cell D. I'm still going to work on Cell
A, but I can't seem to get the ROUND feature to work when
using data from another worksheet to calculate the
percentage. Thank you again.

-----Original Message-----
Perhaps this in cell B:-

=ROUND(CellA,1)*CellC

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Jay" wrote in
message
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another
cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell
C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to
2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value
in
cell A?
Sorry for the long explanation and thank you for any
help.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date:
03/03/2004


.

So where did D come from???? :-)

If you post the cell addresses and the formulas contained within then we'll
happily take another look.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Jay" wrote in message
...
Ken and Bob, thank you. This is what actually solved it
after your helpful suggestions Cell D =ROUND(Cell A,2)
Cell B = Cell C * Cell D. I'm still going to work on Cell
A, but I can't seem to get the ROUND feature to work when
using data from another worksheet to calculate the
percentage. Thank you again.

-----Original Message-----
Perhaps this in cell B:-

=ROUND(CellA,1)*CellC

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Jay" wrote in
message
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another
cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell
C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to
2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value
in
cell A?
Sorry for the long explanation and thank you for any
help.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date:
03/03/2004


.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 04/03/2004

Yeah, D's making it a little nuts, but it works. The
workbook has two sheets - Tallysheet and Totals. The
formulas are on Totals. Here's the original setup:

E2 = 'C:\My Documents\[DAILY FIGURES SHEET(FEBRUARY
2004).xls]Tacoma,Spokane,Kennewick'!$H$31/H2

[H2 = a total from the above workbook of Tac/Spok/Kenn]

C25 = Tallysheet!B35

E25 = C25*E2

E2 was formatted to display as a percentage to 0 decimal
places, but E25 would equal C25 * E2, with E2 rounded to 3
decimal places.

I'd love to see if you have a solution and again thanks
again for all your help.



-----Original Message-----
So where did D come from???? :-)

If you post the cell addresses and the formulas contained
within then we'll
happily take another look.

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Jay" wrote in
message
...
Ken and Bob, thank you. This is what actually solved it
after your helpful suggestions Cell D =ROUND(Cell A,2)
Cell B = Cell C * Cell D. I'm still going to work on
Cell
A, but I can't seem to get the ROUND feature to work
when
using data from another worksheet to calculate the
percentage. Thank you again.

-----Original Message-----
Perhaps this in cell B:-

=ROUND(CellA,1)*CellC

--
Regards
Ken....................... Microsoft
MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------
---
------------------
It's easier to beg forgiveness than ask permission :-)
-------------------------------------------------------
---
------------------



"Jay" wrote in
message
...
I have a formula calculating a percentage. This cell
(A)
is formatted to round to 0 decimal places. In
another
cell
(B) is a formula multiplying cell (C) by the rounded
up
percentage in cell A. However, cell B's result is
cell
C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100
the
resulting Cell B=49.712. I need B to equal 50.
Here's
the kicker, sometimes cell B does need to be rounded
to
2
decimal places so I cannot format the cell to round
to 0
decimal places.

How do I get cell B to multiply by the rounded up
value
in
cell A?
Sorry for the long explanation and thank you for any
help.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
(http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date:
03/03/2004


.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date:
04/03/2004


.

Ken
you're right :-)

--
Regards
Frank Kabel
Frankfurt, Germany

Ken Wright wrote:
Hi Frank - Don't forget the value being rounded is a percentage -
Might need at least one of those places :-)


"Frank Kabel" wrote in message
...
Hi
try the following formula for B1
=ROUND(A1,0)*C

--
Regards
Frank Kabel
Frankfurt, Germany
"Jay" schrieb im Newsbeitrag
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to 2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value in
cell A?
Sorry for the long explanation and thank you for any help.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004

You should know by now that we never get all the information, that would be
too easy.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ken Wright" wrote in message
...
So where did D come from???? :-)

If you post the cell addresses and the formulas contained within then
we'll
happily take another look.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Jay" wrote in message
...
Ken and Bob, thank you. This is what actually solved it
after your helpful suggestions Cell D =ROUND(Cell A,2)
Cell B = Cell C * Cell D. I'm still going to work on Cell
A, but I can't seem to get the ROUND feature to work when
using data from another worksheet to calculate the
percentage. Thank you again.

-----Original Message-----
Perhaps this in cell B:-

=ROUND(CellA,1)*CellC

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Jay" wrote in
message
...
I have a formula calculating a percentage. This cell(A)
is formatted to round to 0 decimal places. In another
cell
(B) is a formula multiplying cell (C) by the rounded up
percentage in cell A. However, cell B's result is cell
C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100 the
resulting Cell B=49.712. I need B to equal 50. Here's
the kicker, sometimes cell B does need to be rounded to
2
decimal places so I cannot format the cell to round to 0
decimal places.

How do I get cell B to multiply by the rounded up value
in
cell A?
Sorry for the long explanation and thank you for any
help.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date:
03/03/2004


.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 04/03/2004

Jay,

I don't know about everyone else, but I've gotten lost now. Would you like
to start again and explain the whole problem?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jay" wrote in message
...
Yeah, D's making it a little nuts, but it works. The
workbook has two sheets - Tallysheet and Totals. The
formulas are on Totals. Here's the original setup:

E2 = 'C:\My Documents\[DAILY FIGURES SHEET(FEBRUARY
2004).xls]Tacoma,Spokane,Kennewick'!$H$31/H2

[H2 = a total from the above workbook of Tac/Spok/Kenn]

C25 = Tallysheet!B35

E25 = C25*E2

E2 was formatted to display as a percentage to 0 decimal
places, but E25 would equal C25 * E2, with E2 rounded to 3
decimal places.

I'd love to see if you have a solution and again thanks
again for all your help.



-----Original Message-----
So where did D come from???? :-)

If you post the cell addresses and the formulas contained
within then we'll
happily take another look.

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Jay" wrote in
message
...
Ken and Bob, thank you. This is what actually solved it
after your helpful suggestions Cell D =ROUND(Cell A,2)
Cell B = Cell C * Cell D. I'm still going to work on
Cell
A, but I can't seem to get the ROUND feature to work
when
using data from another worksheet to calculate the
percentage. Thank you again.

-----Original Message-----
Perhaps this in cell B:-

=ROUND(CellA,1)*CellC

--
Regards
Ken....................... Microsoft
MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------
---
------------------
It's easier to beg forgiveness than ask permission :-)
-------------------------------------------------------
---
------------------



"Jay" wrote in
message
...
I have a formula calculating a percentage. This cell
(A)
is formatted to round to 0 decimal places. In
another
cell
(B) is a formula multiplying cell (C) by the rounded
up
percentage in cell A. However, cell B's result is
cell
C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100
the
resulting Cell B=49.712. I need B to equal 50.
Here's
the kicker, sometimes cell B does need to be rounded
to
2
decimal places so I cannot format the cell to round
to 0
decimal places.

How do I get cell B to multiply by the rounded up
value
in
cell A?
Sorry for the long explanation and thank you for any
help.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
(http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date:
03/03/2004


.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date:
04/03/2004


.

LOL - Like Bob, I'm going "what did he want to do???" because you didn't map
Cells A/B/C/D for us to the references provided, but let's throw a couple of
things out and see what happens:-

I can see that you are bringing data in from another sheet in both E2 and H2.
The data being pulled into E2 from the other book would appear to be a subset of
the total data from the other book, an amount which you are pulling into H2,
so:-

E2 = ExtData1/ExtData2

where ExtData1 is the result of the link you posted, and ExtData2 will be the
result of the link you have in H2 that you did not post

Now I'm assuming you are using H2 for some other purpose as well, because it is
not needed for what I can see so far, as you could have simply put whatever
formula you have used to get H2 into the denominator in E2, and you would still
then have

E2 = ExtData1/ExtData2

If this is the value that you wanted to round, then you can simply wrap it with
the ROUND function, eg:-

E2 = ROUND(ExtData1/ExtData2,2) just substituting

'C:\My Documents\[DAILY FIGURES SHEET(FEBRUARY
2004).xls]Tacoma,Spokane,Kennewick'!$H$31
for ExtData1
and
'C:\My Documents\[DAILY FIGURES SHEET(FEBRUARY
2004).xls]Tacoma,Spokane,Kennewick'!$?$??
for ExtData2 (This one would be whatever formula you currently have in H2).

E2 would now look like the following:-

=ROUND('C:\My Documents\[DAILY FIGURES SHEET(FEBRUARY
2004).xls]Tacoma,Spokane,Kennewick'!$H$31 / 'C:\My Documents\[DAILY FIGURES
SHEET(FEBRUARY 2004).xls]Tacoma,Spokane,Kennewick'!$?$??,2)

And to be honest, as long as you can get the ROUND function under your belt, and
make sure that you wrap ALL the data that needs to be rounded with the function,
then you should have no problems. Now if I haven't helped with any of that,
then I'm back with Bob in that you will probably need to restate the question.

Just bear in mind, that if you ROUND a number, wherever it comes from, and then
divide it by another number, you will not get a rounded answer. Put together
the formula that you want exclusive of any rounding, and then dump that entire
formula into the first argument of the ROUND function - What comes out will then
be rounded.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Jay" wrote in message
...
Yeah, D's making it a little nuts, but it works. The
workbook has two sheets - Tallysheet and Totals. The
formulas are on Totals. Here's the original setup:

E2 = 'C:\My Documents\[DAILY FIGURES SHEET(FEBRUARY
2004).xls]Tacoma,Spokane,Kennewick'!$H$31/H2

[H2 = a total from the above workbook of Tac/Spok/Kenn]

C25 = Tallysheet!B35

E25 = C25*E2

E2 was formatted to display as a percentage to 0 decimal
places, but E25 would equal C25 * E2, with E2 rounded to 3
decimal places.

I'd love to see if you have a solution and again thanks
again for all your help.



-----Original Message-----
So where did D come from???? :-)

If you post the cell addresses and the formulas contained
within then we'll
happily take another look.

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Jay" wrote in
message
...
Ken and Bob, thank you. This is what actually solved it
after your helpful suggestions Cell D =ROUND(Cell A,2)
Cell B = Cell C * Cell D. I'm still going to work on
Cell
A, but I can't seem to get the ROUND feature to work
when
using data from another worksheet to calculate the
percentage. Thank you again.

-----Original Message-----
Perhaps this in cell B:-

=ROUND(CellA,1)*CellC

--
Regards
Ken....................... Microsoft
MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------
---
------------------
It's easier to beg forgiveness than ask permission :-)
-------------------------------------------------------
---
------------------



"Jay" wrote in
message
...
I have a formula calculating a percentage. This cell
(A)
is formatted to round to 0 decimal places. In
another
cell
(B) is a formula multiplying cell (C) by the rounded
up
percentage in cell A. However, cell B's result is
cell
C
times cell A rounded to 3 decimal places.

i.e. Cell A=50% (rounded from 49.712%) Cell C=100
the
resulting Cell B=49.712. I need B to equal 50.
Here's
the kicker, sometimes cell B does need to be rounded
to
2
decimal places so I cannot format the cell to round
to 0
decimal places.

How do I get cell B to multiply by the rounded up
value
in
cell A?
Sorry for the long explanation and thank you for any
help.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
(http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date:
03/03/2004


.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date:
04/03/2004


.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004