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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> >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.
>
>
>