Product - Conditions - Edited Results
THANK YOU!!!! It worked perfectly. I appreciate you and your knowledge.
Chell
"Glenn" wrote:
Glenn wrote:
chelledc wrote:
I have the following.....
A B
1 ?????? Sum=(A1)*(-15%)+A1 To get net
figure for sales
Example
18,358.00 15,604.30
How do I get the answer in B to round up or remove the change?
Any help would be appreciated.
Thanks,
To "round up":
=ROUNDUP(A1*.85,0)
To "remove the change":
=ROUND(A1*.85,0)
Sorry, the second one will round up or down to the closest whole number.
To "remove the change":
=ROUNDDOWN(A1*.85,0)
|