Calculate to 2 places

  • Thread starter Thread starter Garry Fitzgerald
  • Start date Start date
G

Garry Fitzgerald

Hi all

I want to calculate and store too 2 decimal places:

37 * 22.6% =8.362

I want to calculate and store = 8.36

any suggestions most welcome

thanks Garry
 
use the Round function:

Syntax
ROUND(number,num_digits)

Number is the number you want to round.

Num_digits is the number of digits you want to round to. Negative rounds
to the left of the decimal point; 0 (zero) rounds to the nearest integer.



Mauricio Silva
 
Hi all

I want to calculate and store too 2 decimal places:

37 * 22.6% =8.362

I want to calculate and store = 8.36

any suggestions most welcome

thanks Garry
Click to expand...

Use the Round function. E.g.

NewValue: Round([Amount] * [Percentage], 2)

John W. Vinson[MVP]
 
Back
Top