Is there a way to test a formula result in excel and type it only once all within one cell and not using a user defined function

Question

Given the formula:

 =if(a1+b2+c4+g3+b4>10,"No",a1+b2+c4+g3+b4)

Is there any way to not have to type the same a1+b2+c4+g3+b4 twice and have the results be either "No" or the value of a1+b2+c4+g3+b4?

Something like:

 =???(a1+b2+c4+g3+b4,">10","No")

When I want to test a value, I constantly have to enter the same formula twice. If the value meets certain criteria, the results are one thing; otherwise, they are the formula's results.

Answer 1

Use the Let function:

=LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value))

I hope this helps you.