Help with a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1526171%22%20slang%3D%22en-US%22%3EHelp%20with%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526171%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20someone%20help%20me%20with%20this%20formula%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20E14%20says%20Water%20or%20Break%2C%20then%20multiply%20F14%20by%200.15.%26nbsp%3B%20%26nbsp%3BIf%20E14%20says%20office%2C%20then%20add%20a%20zero.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1526171%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%3CLINGO-SUB%20id%3D%22lingo-sub-1526226%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526226%22%20slang%3D%22en-US%22%3E%3DIF(OR(E14%3D%22Water%22%2CE14%3D%22Break%22)%2CF14*0.15%2C0)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Could someone help me with this formula please?

 

If E14 says Water or Break, then multiply F14 by 0.15.   If E14 says office, then add a zero.

 

Thanks

1 Reply
Highlighted
=IF(OR(E14="Water",E14="Break"),F14*0.15,0)