Thread: ROUND
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Novice2000 Novice2000 is offline
external usenet poster
 
Posts: 9
Default 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