Is the value of F200 GREATER than F199? (Your calculating a percentage)
If so, a percentage is actually a decimal number, thus you need to change
formula to:
=ROUNDDOWN(IF(ISBLANK(F124),"no data",F123/F124),2)

--
Best Regards,

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


"PoetsOnMars" wrote:

I neglected to explain in enough detail perhaps:

The Fxxx cell reference in the IF formula is dependent on another cell
reference. The IF function reads:
IF(F199=0,"NO DATA",F199/F200)

In F199 the following formula is present:
=F242, where F242 is a total of possible points tallied in that cell.

Using the formula presented in your post returns a zero value in the cell
regardless of what F199/F200 is.

=ROUNDDOWN(IF(F199=0,"NO DATA",F199/F200),0) = ZERO (blank cell), or

=ROUNDDOWN(IF(ISBLANK(F199),"NO DATA",F199/F200),0) = ZERO (blank cell).

Is that because F199 is actual the F242 reference?

"Luke M" wrote:

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