Multiple IF THEN statements in one cell

By the way, I made a mistake on the code. You mention that you want it to be both 0, so instead of OR(B3=0, C3=0), change it to AND(B3=0, C3=0)

many many thanks. this new correction is exactly what i needed. Thanks!