View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Greg is offline
external usenet poster
 
Posts: 331
Default add Rounding function to this formula

I'm not sure where to insert the round function to this formulas result.
i have tried a couple different things with no resolve.
it needs to be normal rounding .4 down .5 up
=IF(B10="M",IF($C$2-C10<0,0,($C$2-C10)*$B$2),IF($C$3-C10<0,0,($C$3-C10)*$B$3))

Many Thanks in advance.
Greg