Product - Conditions - Edited Results

  • Thread starter Thread starter chelledc
  • Start date Start date
C

chelledc

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,
 
chelledc said:
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,
Click to expand...

To "round up":

=ROUNDUP(A1*.85,0)


To "remove the change":

=ROUND(A1*.85,0)
 
Glenn said:
To "round up":

=ROUNDUP(A1*.85,0)


To "remove the change":

=ROUND(A1*.85,0)
Click to expand...


Sorry, the second one will round up or down to the closest whole number.


To "remove the change":

=ROUNDDOWN(A1*.85,0)
 
Back
Top