View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default how i dow the following formal in excel

=CEILING(A1,10)
or
=ROUNDUP(A1,-1)


"FROM SA" wrote:

hi all

how i can dow the following formail in excel

if i hvae products cost as following

the cost of part $10 but if customer take one the coste will be $10
if take 2 the cost will be same $10
so from 1 to 10 cost will not change and if take 11 part the cost wil be 20 $
12 parts = $20
20 parts = $ 20