I'm new to Excel Formulas that are as extensive as this, yes to me this was hard :P
I wish to add to this Formula as it works as intended:
=IF(AND(MOD(B11,1)>=(7/24),MOD(B11,1)<=(17.5/24)),"Day Shift",IF(OR(MOD(B11,1)<(4.5/24),MOD(B11,1)>=(18/24)),"Night Shift",""))
What I want to add, is the Cell (that I am putting this formula into) just to be Blank if nothing is in the B11 Cell:
=IF(ISBLANK(B11),""))
How do I add this?
Thank you for your time
Please Login or Register to view this content.
Ben Van Johnson
I would just use =if(B11="","",your-formula)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you~!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks