This calculation format driving me nuts

[jjdrake]

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

[#2 · Accepted solution]

How about C = 2375 or 4750?

[#3]

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. 

[#4]

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

[#5]

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

[#6]

my file does not work for C=lower bound or C=upper bound. You have to adjust the formula for your needs.

[#7]

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!