Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lynne
 
Posts: n/a
Default round up a function RESULT

I know how to round a cell, I know how to set up a function in a cell but I
am trying to round the result of the function that I have already set up in
the cell

=PRODUCT(I62,D63) - is the current cell function
I am taking that and the next step is multiplying that to get a
percentage.... .025 percent....that ends up equaling something like 1434 and
I need to get that cell to

ROUND up to the next 50 or round down 50....does this makes sense?....it is
driving me crazy your help is greatly appreciated!!!
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default round up a function RESULT

=ceiling(i62*d63,50)
or
=floor(i62*d63,50)

Take a look at excel's help for more info.


Lynne wrote:

I know how to round a cell, I know how to set up a function in a cell but I
am trying to round the result of the function that I have already set up in
the cell

=PRODUCT(I62,D63) - is the current cell function
I am taking that and the next step is multiplying that to get a
percentage.... .025 percent....that ends up equaling something like 1434 and
I need to get that cell to

ROUND up to the next 50 or round down 50....does this makes sense?....it is
driving me crazy your help is greatly appreciated!!!


--

Dave Peterson
  #3   Report Post  
Gary''s Student
 
Posts: n/a
Default round up a function RESULT

Take a look at =CEILING() For example =CEILING(your expression,50)
--
Gary's Student


"Lynne" wrote:

I know how to round a cell, I know how to set up a function in a cell but I
am trying to round the result of the function that I have already set up in
the cell

=PRODUCT(I62,D63) - is the current cell function
I am taking that and the next step is multiplying that to get a
percentage.... .025 percent....that ends up equaling something like 1434 and
I need to get that cell to

ROUND up to the next 50 or round down 50....does this makes sense?....it is
driving me crazy your help is greatly appreciated!!!

  #4   Report Post  
Niek Otten
 
Posts: n/a
Default round up a function RESULT

Use the MROUND() function. If you get a #NAME error, ToolsAdd-ins, check
Analysis Toolpak
To multiply numbers, you don't need the PRODUCT function. You can use the
multiplication sign instead, if you wish.
Did you really mean .025 percent or did you mean multiply by .025?

Your formula might be something like

=MROUND (I62*D63*.025,50) or =MROUND(I62*D63*2.5%,50)

--
Kind regards,

Niek Otten

"Lynne" wrote in message
...
I know how to round a cell, I know how to set up a function in a cell but I
am trying to round the result of the function that I have already set up
in
the cell

=PRODUCT(I62,D63) - is the current cell function
I am taking that and the next step is multiplying that to get a
percentage.... .025 percent....that ends up equaling something like 1434
and
I need to get that cell to

ROUND up to the next 50 or round down 50....does this makes sense?....it
is
driving me crazy your help is greatly appreciated!!!



  #5   Report Post  
Niek Otten
 
Posts: n/a
Default round up a function RESULT

Dave and Gary' student are probably right, but the

<ROUND up to the next 50 or round down 50....

made me think you just wanted to round, not round up

Anyway, you may have enough stuff now to get it sorted out; if not, post
again in this same thread

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
Use the MROUND() function. If you get a #NAME error, ToolsAdd-ins, check
Analysis Toolpak
To multiply numbers, you don't need the PRODUCT function. You can use the
multiplication sign instead, if you wish.
Did you really mean .025 percent or did you mean multiply by .025?

Your formula might be something like

=MROUND (I62*D63*.025,50) or =MROUND(I62*D63*2.5%,50)

--
Kind regards,

Niek Otten

"Lynne" wrote in message
...
I know how to round a cell, I know how to set up a function in a cell but
I
am trying to round the result of the function that I have already set up
in
the cell

=PRODUCT(I62,D63) - is the current cell function
I am taking that and the next step is multiplying that to get a
percentage.... .025 percent....that ends up equaling something like 1434
and
I need to get that cell to

ROUND up to the next 50 or round down 50....does this makes sense?....it
is
driving me crazy your help is greatly appreciated!!!





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
Value or function as result.... Jan Jansens Excel Worksheet Functions 0 September 5th 05 02:23 PM
EXCEL:NUMBER TO GREEK WORDS vag Excel Worksheet Functions 1 June 15th 05 05:57 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM


All times are GMT +1. The time now is 04:08 AM.

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

About Us

"It's about Microsoft Excel"