Nov 16 2020 02:14 PM
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
Nov 16 2020 02:24 PM
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)"?
Nov 16 2020 06:38 PM
Nov 17 2020 12:46 AM
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.