Product - Conditions - Edited Results
 

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,

Product - Conditions - Edited Results
 

Roundup: =CEILING(A1*(1-15%),1)

remove the change: =FLOOR(A1*(1-15%),1)

--
__________________________________
HTH

Bob

"chelledc" wrote in message
...
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,

Product - Conditions - Edited Results
 

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)

Product - Conditions - Edited Results
 

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)

Product - Conditions - Edited Results
 

Thank you!!!! I appreciate you and your knowledge!

"Bob Phillips" wrote:

Roundup: =CEILING(A1*(1-15%),1)

remove the change: =FLOOR(A1*(1-15%),1)

--
__________________________________
HTH

Bob

"chelledc" wrote in message
...
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,

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)