Wroking with rounded or trunc calculation
 

I am creating a form for employees to fill in. One of the automated
calculations will be a percent that I will either round or truncate to 1
decimal (ex: 15.1%). How do I then use the exact number visible to have the
form do another automatic calculation in another cell? In other words, I
want the 15.1% to be used instead of a number like 15.094321.

Tools - Options - Calculation

Precision as displayed.

"Wendy - Payroll" wrote in message
...
I am creating a form for employees to fill in. One of the automated
calculations will be a percent that I will either round or truncate to 1
decimal (ex: 15.1%). How do I then use the exact number visible to have
the
form do another automatic calculation in another cell? In other words, I
want the 15.1% to be used instead of a number like 15.094321.

Just wrap your formula in the Round() function, and the return from that
will be the actual value used:

=Round("your formula",1)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Wendy - Payroll" wrote in message
...
I am creating a form for employees to fill in. One of the automated
calculations will be a percent that I will either round or truncate to 1
decimal (ex: 15.1%). How do I then use the exact number visible to have
the
form do another automatic calculation in another cell? In other words, I
want the 15.1% to be used instead of a number like 15.094321.

Thank you!!!!

"Barb Reinhardt" wrote:

Tools - Options - Calculation

Precision as displayed.

"Wendy - Payroll" wrote in message
...
I am creating a form for employees to fill in. One of the automated
calculations will be a percent that I will either round or truncate to 1
decimal (ex: 15.1%). How do I then use the exact number visible to have
the
form do another automatic calculation in another cell? In other words, I
want the 15.1% to be used instead of a number like 15.094321.