AboutPricing

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.
< Go Back

    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