View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PoetsOnMars PoetsOnMars is offline
external usenet poster
 
Posts: 7
Default rounddown + if function

have if function that I need to rounddown the results for, which are in
percentage format. function says 'if cell x is empty,"no data",f123/f124' -
want the dividend to rounddown to 0 decimal places. can't seem to combine
=rounddown(if ...)