Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2176491%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2176491%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20some%20help%20again.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20figure%20out%20a%20formula%20that%20returns%20a%20value%20if%20another%20cell%20contains%20a%20set%20of%20information.%20Attached%20is%20the%20template%20I'm%20working%20on%20and%20I've%20detailed%20the%20criteria%20on%20the%20spreadsheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20really%20appreciate%20some%20assistance%20again.%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2176491%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Looking for some help again. 

 

I need to figure out a formula that returns a value if another cell contains a set of information. Attached is the template I'm working on and I've detailed the criteria on the spreadsheet. 

 

I'd really appreciate some assistance again.

Thanks,

 

1 Reply

@62Mojo Try this:

 

=IF(M9="N/A",0,N9)