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.
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.
Last edited by chriswhite1982; 06-18-2013 at 05:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks