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 formulas together and make it calculate properly for any value of the "C". Thanks in advance


excel
Formulas and Functions

6 Replies

    • 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?

Resources