View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean Jean is offline
external usenet poster
 
Posts: 78
Default Decimal question in variable?

Hi,
I would like to know if it exists a function to round up or down a three or
more decimal at only two,
I am not talking about the content of a cell but at the content of a variable
Ex: B = 13.34567
A = 13.35
C = A - B
I would like In this Example the result of C to be 0.
In fact I would like round up B to be 13.35.
or 13.34 if B was 13.34458

Thank you very much

Jean