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

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

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

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

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

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

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

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