Forum Discussion
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...
=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.
Willy,
I'm trying to get my head around this. I got it to partially work but it seems to be working opposite.
=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.