Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
round up the number
Hi,
I have a table below: A B C 1. 123.60 12 2. 178.40 8 How can I set a formular to get the following results: C1 = 124 * B1 (A1's 123.60 round up to 124) C2 = 178 * B2 (A2's 178.40 round up to 178) thanks in advance! Lowan -- Lowan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
round up the number
Try:
=ROUNDUP(A2,0)*B2 "Lowan Chan" wrote: Hi, I have a table below: A B C 1. 123.60 12 2. 178.40 8 How can I set a formular to get the following results: C1 = 124 * B1 (A1's 123.60 round up to 124) C2 = 178 * B2 (A2's 178.40 round up to 178) thanks in advance! Lowan -- Lowan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
round up the number
=ROUND(A1,0)*B1
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Lowan Chan" wrote in message ... Hi, I have a table below: A B C 1. 123.60 12 2. 178.40 8 How can I set a formular to get the following results: C1 = 124 * B1 (A1's 123.60 round up to 124) C2 = 178 * B2 (A2's 178.40 round up to 178) thanks in advance! Lowan -- Lowan |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
round up the number
Sorry, I see your second example. Try:
=ROUND(A2,0)*B2 "Damon Longworth" wrote: Try: =ROUNDUP(A2,0)*B2 "Lowan Chan" wrote: Hi, I have a table below: A B C 1. 123.60 12 2. 178.40 8 How can I set a formular to get the following results: C1 = 124 * B1 (A1's 123.60 round up to 124) C2 = 178 * B2 (A2's 178.40 round up to 178) thanks in advance! Lowan -- Lowan |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
round up the number
Thanks Damon.
I have one problem, your format only round up A2 to 179, but I need the result is 178. What else I can do? Thank you! -- Lowan "Damon Longworth" wrote: Try: =ROUNDUP(A2,0)*B2 "Lowan Chan" wrote: Hi, I have a table below: A B C 1. 123.60 12 2. 178.40 8 How can I set a formular to get the following results: C1 = 124 * B1 (A1's 123.60 round up to 124) C2 = 178 * B2 (A2's 178.40 round up to 178) thanks in advance! Lowan -- Lowan |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
round up the number
"Lowan Chan" wrote:
Subject: round up the number How can I set a formular to get the following results: C1 = 124 * B1 (A1's 123.60 round up to 124) =ROUNDUP(A1,0)*B1 But.... C2 = 178 * B2 (A2's 178.40 round up to 178) 178.40 does not round __up__ [sic] to 178. It rounds down. I think you want to __round__, namely: =ROUND(A2,0)*B2 probably for both A1 and A2. ----- original message ----- "Lowan Chan" wrote: Hi, I have a table below: A B C 1. 123.60 12 2. 178.40 8 How can I set a formular to get the following results: C1 = 124 * B1 (A1's 123.60 round up to 124) C2 = 178 * B2 (A2's 178.40 round up to 178) thanks in advance! Lowan -- Lowan |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
round up the number
See if this works, I'm a bit unlearned on ROUND.
=ROUND(A1,0)*B1 Returns 1428 HTH Regards, Howard "Lowan Chan" wrote in message ... Hi, I have a table below: A B C 1. 123.60 12 2. 178.40 8 How can I set a formular to get the following results: C1 = 124 * B1 (A1's 123.60 round up to 124) C2 = 178 * B2 (A2's 178.40 round up to 178) thanks in advance! Lowan -- Lowan |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
round up the number
If you want to change 178.4 to 178, not 178, you want to *round*, not round
up. Change Damon's formula to: =Round(a2,0)*b2 Regards Fred "Lowan Chan" wrote in message ... Thanks Damon. I have one problem, your format only round up A2 to 179, but I need the result is 178. What else I can do? Thank you! -- Lowan "Damon Longworth" wrote: Try: =ROUNDUP(A2,0)*B2 "Lowan Chan" wrote: Hi, I have a table below: A B C 1. 123.60 12 2. 178.40 8 How can I set a formular to get the following results: C1 = 124 * B1 (A1's 123.60 round up to 124) C2 = 178 * B2 (A2's 178.40 round up to 178) thanks in advance! Lowan -- Lowan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round number to the thousands without changing underlying number | Excel Discussion (Misc queries) | |||
Excel. How to round a number to nearest half number? | Excel Discussion (Misc queries) | |||
Can I increase a number by 5.5% and then round that number to the. | Excel Discussion (Misc queries) | |||
How can i round a number to closest tenth number? | Excel Worksheet Functions | |||
How to make a number round up/down to a set number | Excel Worksheet Functions |