View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sally Sibthorpe[_2_] Sally Sibthorpe[_2_] is offline
external usenet poster
 
Posts: 1
Default Rounding down with a calculation

Hi, I could use some help. I saw lots of answers on how to round down when a
cell has a function in it (like IF, SUM), but how do you do it with a mere
calculation?

This is the data
c5 d5 e5
2.50% 25 =d5*c5

How do I round the result down to 2 digits? I tried using the ROUNDDOWN
function, bul all I get are errors. I used this forumula
=ROUNDDOWN((e5,2)d5*c5)) and got the errors.

I am in Excel 2003, by the way.