Get instant live expert help on I need help with excel mod function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

average if function correction for mod 8
Solved by G. E. in 11 mins
I realized that the MOD() function won't work with what I'm doing by itself, I need further help. Thanks.
Solved by T. J. in 24 mins
=IF(AND(e2<=50), e2*114%*120%) =e2-MOD(e2,10)+4*(MOD(e2,10)>5)+5
Solved by I. B. in 29 mins
I am trying out a formula I saw in google but its not working in my excel and producing an error. Can you please help me? =(NETWORKDAYS(StartDT,EndDT)-1)*(StopTime-StartTime)+IF(NETWORKDAYS(EndDT,EndDT),MEDIAN(MOD(EndDT,1),StopTime,StartTime),StopTime)-MEDIAN(NETWORKDAYS(StartDT,StartDT)*MOD(StartDT,1),StopTime,StartTime)
Solved by T. U. in 29 mins
I need help with this formula. I need this to include months =INT((M4)/7)&" weeks"&IF(MOD(M4,7)=0,"",", "&INT(MOD(M4,7))&" days") I have the number of Days to Start with
Solved by F. A. in 19 mins