Forum Discussion

Randy Taillon's avatar
Randy Taillon
Copper Contributor
Feb 06, 2018
Solved

Nested IF

Hello,   I need a little nudge on a formula.   I am working on a spreadsheet that calculates day rates for my business.    Let's say a day is ten hours and the rate for that day is 1000 d...
Formulas & Functions
Need Help
  • Willy Lau's avatar
    Willy Lau
    Feb 07, 2018
    =IF(C3,C3*F3,IF(D3,D3*F3,(INT(b3)+MAX((MOD(b3,1)>=0.5)*0.65, MOD(b3,1)))*f3))

    I didn't know if this meet your needs.  

Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Feb 07, 2018
Hi Randy

Are you able to upload a sample of the spreadsheet? Might be good to see what you are working with!

Cheers
Damien

Resources