View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
egarcia egarcia is offline
external usenet poster
 
Posts: 13
Default conditional rounding

My current formula is =ROUNDDOWN(AB15/$AB$36,0). I want to change it to = 0
if it's zero. If the number is between .1 to .9 i want it to equal 1. If it's
greater than 1 I want it to round down. Can u help me?