Wroking with rounded or trunc calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
==============================================
 
Back
Top