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.  

Randy Taillon's avatar
Randy Taillon
Copper Contributor
Feb 07, 2018

Damien,

 

You understood me perfectly. 

 

While it's unlikely I'll use a decimal other than .5, I would prefer to preserve the ability to do so. I did not however state that in previous posts.

 

I think I get it now. The magic lies in INT. Basically, the formula says if it's a whole number, multiply by 1000 (or F3) and if it contains a decimal, substitute .65 for whatever the decimal is.

 

I'm glad I got two different responses. That gave me a couple ways to look at it and made it click for. I will use both versions. Yours I will use to distribute to staff that don't have the authority to change pricing and Willy's I will use in my version.

 

Thanks! I sincerely appreciate both of you being willing to help out.

 

 

Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Feb 07, 2018
Thanks for the kind words Randy. I think we (in the tech community) just have an awesome amount of fun helping good people like yourself problem solve things.

We're always here if you need anything!

Best wishes
Damien

Resources