Forum Discussion

jjdrake's avatar
jjdrake
Copper Contributor
Feb 01, 2018
Solved

This calculation format driving me nuts

Hi there! I've been trying for two days to make this formula work but unsuccessfully. I have 3 conditions and 2 results depending on these 3 conditions. Can somebody please help me to put these two f...
excel
Formulas and Functions
jjdrake's avatar
jjdrake
Copper Contributor
Feb 01, 2018

Sorry, I don't understand your question. "C" can be 2375 or 4750, these two numbers are some predefined constants which makes 3 conditions possible. 

  • Willy Lau's avatar
    Willy Lau
    Iron Contributor
    Feb 01, 2018

    From your condition, if c = 2375, r1 =0? or r1=c*0.1?

    • jjdrake's avatar
      jjdrake
      Copper Contributor
      Feb 01, 2018

      Sorry, I haven't seen your calculation from the mobile. I tested it, works just great. Thanks so much, You are saver! Cheers!

      • Willy Lau's avatar
        Willy Lau
        Iron Contributor
        Feb 01, 2018
        my file does not work for C=lower bound or C=upper bound. You have to adjust the formula for your needs.

Resources