looking for help with a specific formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1892627%22%20slang%3D%22en-US%22%3Elooking%20for%20help%20with%20a%20specific%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1892627%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20to%20get%20help%20with%20a%20formula%2C%20The%20function%20I%20am%20trying%20to%20perform%20is%20that%20if%20text%20in%20a%20certain%20column%20says%20XXX%2C%20then%20columns%20X%2C%20X%20and%20X%20will%20return%20a%200.%20Below%20is%20what%20I%20have%20but%20is%20not%20working%20correctly%20or%20as%20I%20thought%20it%20would%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND(%5B%40Inherited%5D%3D%22DoD%20Tier%201%20Common%20Control%20Provider%20(DoD%20Tier1%20CCP%2C%20304%2C%20Army)%22)%2C%5B%40Raw%20Vulnerability%20Severity%5D%3D%220%22%5B%40Likelihood%5D%3D%220%22%2C%5B%40Impact%5D%3D%220%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1892627%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1892665%22%20slang%3D%22en-US%22%3ERe%3A%20looking%20for%20help%20with%20a%20specific%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1892665%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F870921%22%20target%3D%22_blank%22%3E%40thomasjt1%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EWhat%20do%20you%20want%20to%20return%20in%20the%20Raw%20Vulnerability%20Severity%2C%20Likelihood%20and%20Impact%20columns%20when%20Inherited%20is%20NOT%20equal%20to%20%22DoD%20Tier%201%20Common%20Control%20Provider%20(DoD%20Tier1%20CCP%2C%20304%2C%20Army)%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1893101%22%20slang%3D%22en-US%22%3ERe%3A%20looking%20for%20help%20with%20a%20specific%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1893101%22%20slang%3D%22en-US%22%3EI%20would%20like%20them%20to%20stay%20blank%20so%20numbers%20could%20be%20added%20via%20a%20drop%20down%20if%20that%20is%20possible.%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies

@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)"?

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

@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.