Add "IF" to existing "MOD" cell forumla

I have a formula in cell "M4", "=MOD($D$30+'Admin Data'!$B$9,1)" that is formatted for time (This is an Overtime program). Is there a way to add to the formula that if Cell J12 = "Off" that "Off" will appear in cell "M4"? Thank you.

try this:

=if(J12="Off","Off",MOD($D$30+'Admin Data'!$B$9,1))

Depends if J12 can have other values.

If J12 is blank or "yes", then just:

cell M4, =MOD($D$30+'Admin Data'!$B$9,1) & " " & $J$12

or

cell M4, =$J$12 & " " & MOD($D$30+'Admin Data'!$B$9,1)


If J12 could be Yes or No, then maybe:

cell M4, =MOD($D$30+'Admin Data'!$B$9,1) & IF($J$12="yes", " " & $J$12, "")


If it's an either/or

cell M4, =IF($J$12="yes", $J$12, MOD($D$30+'Admin Data'!$B$9,1))


Anyway, some options to consider.


Regards, TMS

If you intend to drag the formula down the column, you may want to make the cell reference absolute: $J$12

Regards, TMS

You're welcome.