View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
spence spence is offline
external usenet poster
 
Posts: 25
Default ROUND the result of a formula

I have the following formula and need the result to round to two decimal
points:

=IF(ISBLANK(B12),"",IF(AND(D12=IFIS!$C$2,$F$3<"G B"),$D$5*1.056,$D$5))

Currently the result is displaying rounded down to two decimal points but I
need the actual value to be two decimal points since it is used for other
calculations.

Thanks for any assistance.

spence