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
  • Willy Lau's avatar
    Willy Lau
    Feb 01, 2018

    How about C = 2375 or 4750?

     

     

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

How about C = 2375 or 4750?

 

 

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

Resources