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.
      • jjdrake's avatar
        jjdrake
        Copper Contributor
        Feb 02, 2018

        Have some new moments here. New condition. Please, take a look and help me. I can't manage to put everything to work. Something is always missing. Thank you!

Resources