| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a cell round to another cell?
One way:
A1: 0.02 B2: 0.05 C2: =ROUND(B2/$A$1,0)*$A$1 In article . com, Aaron wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a cell round to another cell?
One way:
A1: 0.02 B2: 0.05 C2: =ROUND(B2/$A$1,0)*$A$1 In article . com, Aaron wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a cell round to another cell?
=MROUND(Answercell,Keycell).
-- David Biddulph "Aaron" wrote in message ups.com... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a cell round to another cell?
CEILING(Answercell, Keycell)
Will (always) round up to the nearest multiple of Keycell. Use MROUND if you need it to round down, otherwise this works. On Aug 9, 4:00 am, "David Biddulph" <groups [at] biddulph.org.uk wrote: =MROUND(Answercell,Keycell). -- David Biddulph "Aaron" wrote in message ups.com... 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.- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a cell round to another cell?
MROUND doesn't automatically round down; it rounds to the *nearest*. It is
FLOOR that rounds down (analagous to CEILING rounding up). -- David Biddulph "ilia" wrote in message ups.com... CEILING(Answercell, Keycell) Will (always) round up to the nearest multiple of Keycell. Use MROUND if you need it to round down, otherwise this works. On Aug 9, 4:00 am, "David Biddulph" <groups [at] biddulph.org.uk wrote: =MROUND(Answercell,Keycell). -- David Biddulph "Aaron" wrote in message ups.com... 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.- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make a cell round to another cell?
On Aug 10, 3:49 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote: MROUND doesn't automatically round down; it rounds to the *nearest*. It is FLOOR that rounds down (analagous to CEILING rounding up). -- David Biddulph "ilia" wrote in message ups.com... CEILING(Answercell,Keycell) Will (always) round up to the nearest multiple ofKeycell. Use MROUND if you need it to round down, otherwise this works. On Aug 9, 4:00 am, "David Biddulph" <groups [at] biddulph.org.uk wrote: =MROUND(Answercell,Keycell). -- David Biddulph "Aaron" wrote in message roups.com... Hi, How can I make a cell with a number in it round to another cells number. IEKeycellis 0.02 and Answercell is 0.05 but I need it to only show numbers in multiples of theKeycellso in this example it would round up to 0.06? Cheers, Aaron.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Thankyou everyone for your help, I will put these to the tst on my spreadsheet. Cheers, Aaron. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| Sum and Round all in one cell | Excel Discussion (Misc queries) | |||
| Excell- a value in a cell, round it up by fives in another cell | New Users to Excel | |||
| round up in own cell | Excel Worksheet Functions | |||
| Multiply one cell by a factor and make that result round | Excel Worksheet Functions | |||
Linear Mode
