LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 59
Default How do I make a cell round to another cell?

Hi,

How can I make a cell with a number in it round to another cells
number.

IE Keycell is 0.02 and Answercell is 0.05 but I need it to only show
numbers in multiples of the Keycell so in this example it would round
up to 0.06?

Cheers,

Aaron.

 
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
How can I make a blank cell in a formula cell with a range of cell Vi Excel Discussion (Misc queries) 5 June 21st 07 02:46 PM
Sum and Round all in one cell BAHoffman Excel Discussion (Misc queries) 4 November 21st 06 09:38 PM
Excell- a value in a cell, round it up by fives in another cell lpp123 New Users to Excel 3 June 23rd 06 04:39 PM
round up in own cell Tim Excel Worksheet Functions 3 June 20th 05 03:15 AM
Multiply one cell by a factor and make that result round Machel_C Excel Worksheet Functions 7 March 15th 05 08:04 PM


All times are GMT +1. The time now is 03:32 PM.

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

About Us

"It's about Microsoft Excel"