Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 30th 08, 07:54 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 3
Default 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   Report Post  
Old July 30th 08, 08:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 2,420
Default 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   Report Post  
Old July 30th 08, 08:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1,240
Default 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   Report Post  
Old July 30th 08, 08:13 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1,240
Default 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   Report Post  
Old July 31st 08, 02:31 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 3
Default 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   Report Post  
Old July 31st 08, 02:32 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PRODUCT RESULTS/VALUE ARE NOT CALCULATING CORRECTLY EnergyMuse Excel Worksheet Functions 1 January 16th 07 10:16 PM
Go to Last edited cell Manju Excel Worksheet Functions 3 August 30th 06 03:01 PM
Show last edited by Dave H Setting up and Configuration of Excel 2 June 13th 06 04:13 PM
Date last edited Mike Sharp Excel Discussion (Misc queries) 1 May 18th 05 06:08 PM
Links Cannot Be Edited BOB Excel Worksheet Functions 1 January 14th 05 04:09 AM


All times are GMT +1. The time now is 08:34 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017