Maximum number in calculation

[Fancher]

I need to write a formula of A + B = C, where B must be less than 30% of C.

So, if A = 100,000 and B = 50,000, B is reduced to 42,857 and C = 142,857

Thanks.

 

[JamesCanale]

=A+min(.3*C,B)

 

[Joe4]

Welcome to the Board!

Formula in cell C2:

=MIN((A2/0.7)-A2,B2)

Formula in cell D2:

=A2+C2

 

[Fancher]

Thank you. I appreciate it.

 

[Joe4]

You are welcome.
Glad we could help!