T
Tom Hall
IF(D18<>"",D18*K18,"")
D18 is time expressed as hours in decimal fractions - i.e., 5.5 equals 5
hours and 30 minutes.
K18 is a dollar amount expressed as an exact currency value, i.e., $17.50
or $20.00
There are a number of these formulas in the worksheet, and at the bottom of
the column the results are summed.
What I am trying to do is round each result so that values are limited to
$xx.yy instead of the full numerical calculation carried out by the above
formula. IOW, I want the result to be $15.25, not $15.2475
I've been unable so far to come up with any use of the ROUND or related
functions to deal wth the result in this formula such that the sum will be
exactly what one would expect from adding the dollars and cents. In most
cases, the sum of these values is off by a penny.
It seems to me that the IF condition is throwing me off, but I don't want
to eliminate it because I don't want a cell to contain $0.00 if there's no
value for D.
TIA,
Tom
D18 is time expressed as hours in decimal fractions - i.e., 5.5 equals 5
hours and 30 minutes.
K18 is a dollar amount expressed as an exact currency value, i.e., $17.50
or $20.00
There are a number of these formulas in the worksheet, and at the bottom of
the column the results are summed.
What I am trying to do is round each result so that values are limited to
$xx.yy instead of the full numerical calculation carried out by the above
formula. IOW, I want the result to be $15.25, not $15.2475
I've been unable so far to come up with any use of the ROUND or related
functions to deal wth the result in this formula such that the sum will be
exactly what one would expect from adding the dollars and cents. In most
cases, the sum of these values is off by a penny.
It seems to me that the IF condition is throwing me off, but I don't want
to eliminate it because I don't want a cell to contain $0.00 if there's no
value for D.
TIA,
Tom