Thread: round up the number
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default 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

Reply With QuoteReply With Quote