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 said:
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
---------------------------------------------------------- ------------------
---
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
.
