=ROUNDDOWN(IF(ISBLANK(F124),"no data",F123/F124),0)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"PoetsOnMars" wrote:

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 ...)