| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PRODUCT RESULTS/VALUE ARE NOT CALCULATING CORRECTLY | Excel Worksheet Functions | |||
| Go to Last edited cell | Excel Worksheet Functions | |||
| Show last edited by | Setting up and Configuration of Excel | |||
| Date last edited | Excel Discussion (Misc queries) | |||
| Links Cannot Be Edited | Excel Worksheet Functions | |||
Linear Mode
