N
Nettie
I am working on a Human Relations appraisal form in InfoPath to supplement
and eventually replace a pre-exising form in Excel. There are several
formulas that feed into each other to get a final appraisal rating.
Currently, the form in Excel, shows all numbers at 1 decimal place and we
have selected 'precision as displayed' to make sure all the rounding works
out at the end. In Infopath, if I select 1 decimal place, 2.2 will show up
for 2.28, etc. Also, there is a rounding function but it only rounds to the
nearest integer? Is there a way to work around this? I need to make the
Infopath form exactly the same as the Excel form in terms of rounding rules.
and eventually replace a pre-exising form in Excel. There are several
formulas that feed into each other to get a final appraisal rating.
Currently, the form in Excel, shows all numbers at 1 decimal place and we
have selected 'precision as displayed' to make sure all the rounding works
out at the end. In Infopath, if I select 1 decimal place, 2.2 will show up
for 2.28, etc. Also, there is a rounding function but it only rounds to the
nearest integer? Is there a way to work around this? I need to make the
Infopath form exactly the same as the Excel form in terms of rounding rules.