NumberFormat(Evaluate(RETAIL1-(RETAIL1 * DiscountRate)), "999,999,999.00")
So, say we plug some numbers in there:
Retail Value: $82 dollars
Discount Rate: 5.25% off
NumberFormat(Evaluate(82-(82 * 0.0525)), "999,999,999.00")
The actual result of 82-(82 * 0.0525) is 77.695, so I need that number
to round up to 77.70. Instead, using the NumberFormat function results
in a value of 77.69. How can I make this round up correctly!?
Thanks in advance for any help anyone can offer!
--
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
