Updating an Existing Formula (Override Logic)

[bdav1216]

See the attached spreadsheet.

I need assistance updating the 4 columns (CB, CC, CD and CE).

If Column G = "As-Is (No Changes)"
AND
If Column N = "1"
AND
If Column R = "1"

then....Update each of the 4 columns above to reset/override the value of these columns to a value of 10.

Currently, these columns use the a combination of other columns and VLOOKUP's to create a value/overall weight, but for this specific condition, I would like to override/reset the value to "10"

[finalazy]

Hmm not sure if you mean to show result of 10 if condition met or reset it to 10 within the code and recalculate the overall weight.
But if you mean to show result of 10, you can just add the IF condition in front of your existing code in CB,CC,CD,CE.

IF(AND(G2="As-Is (No Changes)",N2=1,R2=1),10,"Your existing code" and add additional ) at the end

But i think you mean the other way.

[bdav1216]

Hmm not sure if you mean to show result of 10 if condition met or reset it to 10 within the code and recalculate the overall weight.
But if you mean to show result of 10, you can just add the IF condition in front of your existing code in CB,CC,CD,CE.

IF(AND(G2="As-Is (No Changes)",N2=1,R2=1),10,"Your existing code" and add additional ) at the end

But i think you mean the other way.

Think of a value of '10' as the result of those calculations as a way to override everything else going on in those formula's IF the initial statement is true.

So if these initial conditions are true, I don't care about anything else in that formula. I expect a value of '10' to be output.

[davsth]

Well I think you have your answer provided bdav