Wroking with rounded or trunc calculation

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.
 
R

RagDyer

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Stop Excel from displaying rounded values 4
subtraction returning incorrect calue 5
INT ROUND & TRUNC 2
Calculate to the third decimal and round up or down in cell 6
save rounded value 3
TRUNC vs ROUND 7
How to round a number up or down 3
Interest calculation 14

Top