View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fontsie
 
Posts: n/a
Default a little help pls

Hello,

Do you mean that no matter what the cent value is, you want it to be
".95"?

In that case, how about using the Integer function:
C1=INT(A1*B1)+.95

Hope that helps,