looking for help with a specific formula

[thomasjt1]

I am looking to get help with a formula, The function I am trying to perform is that if text in a certain column says XXX, then columns X, X and X will return a 0. Below is what I have but is not working correctly or as I thought it would

=IF(AND([@Inherited]="DoD Tier 1 Common Control Provider (DoD Tier1 CCP, 304, Army)"),[@Raw Vulnerability Severity]="0"[@Likelihood]="0",[@Impact]="0"

Any help would be appreciated

[#2]

@thomasjt1

What do you want to return in the Raw Vulnerability Severity, Likelihood and Impact columns when Inherited is NOT equal to "DoD Tier 1 Common Control Provider (DoD Tier1 CCP, 304, Army)"?

[#3]

I would like them to stay blank so numbers could be added via a drop down if that is possible.

[#4]

@thomasjt1 

You can't do that with a formula - entering a number in one of those columns would overwrite the formula. You'd need VBA code. If you want help with that, we'd have to know more about the worksheet.