Help with a formula

Copper Contributor

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
=IF(OR(E14="Water",E14="Break"),F14*0.15,0)