Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

How do I multiple a number after it rounds up?

Avatar

Avatar
Validate 1
Level 3
jeanette614
Level 3

Likes

5 likes

Total Posts

129 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 3
jeanette614
Level 3

Likes

5 likes

Total Posts

129 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
jeanette614
Level 3

30-12-2013

I have a form asking for miles traveled. I need what they enter to round up to the next nearest whole mile. I have called that field "mileage". I have set it to whole numbers and it rounds up nicely for display. Now I need to multiple that new rounded "mileage" number by .56 (that field is called "auto"). What I currently have in the "auto" field is: mileage*.56  Unfortunately, it still uses whatever they type in to calculate with and not the rounded up "mileage" whole number.

What script do I need on which field to make the 56 cent calculation apply to the rounded up mileage and not the entered amount which it's currently doing?

View Entire Topic

Avatar

Avatar
Validate 1
Level 3
jeanette614
Level 3

Likes

5 likes

Total Posts

129 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 3
jeanette614
Level 3

Likes

5 likes

Total Posts

129 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
jeanette614
Level 3

30-12-2013

Thank you for your patience and yes, you're a genius, it works perfectly. Now I can finish out my project and know that it works well. Have a great New Year's.