ROUND
 

I need to know how to rewrite the following formula to round to 2 decimals,
not just display two decimals. Round down, round up I am not sure which.

=IF(B10="","",(B10*$A$8%))

this results in a number like this: 26.2529

The problem is that this is used in another formula and because the first
amount wan't rounded it throws off the calculation. Thanks

ROUND
 

Maybe this is what you want:

=IF(B10="","",(ROUND(B10*$A$8%,2)))

HTH,
Paul

"Novice2000" wrote in message
...
I need to know how to rewrite the following formula to round to 2 decimals,
not just display two decimals. Round down, round up I am not sure which.

=IF(B10="","",(B10*$A$8%))

this results in a number like this: 26.2529

The problem is that this is used in another formula and because the first
amount wan't rounded it throws off the calculation. Thanks

ROUND
 

Perfect. Thanks very much.


"PCLIVE" wrote:

Maybe this is what you want:

=IF(B10="","",(ROUND(B10*$A$8%,2)))

HTH,
Paul

"Novice2000" wrote in message
...
I need to know how to rewrite the following formula to round to 2 decimals,
not just display two decimals. Round down, round up I am not sure which.

=IF(B10="","",(B10*$A$8%))

this results in a number like this: 26.2529

The problem is that this is used in another formula and because the first
amount wan't rounded it throws off the calculation. Thanks