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,
|