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
.