Help!

Occasional Visitor

 

If I type in a certain text - “W” - (cell A3) I want it to multiply two other cells (cells A1*A2) and display result in (cell A4)

 

If I type in another text - “L” - (A3) I want it to multiply one cell (A1) by 0 and display result in (A4)

 

1 Reply

@brownnick Perhaps this formula in A4:

 

=IF(A3="W",A1*A2,0)

 

This will only look if A3 contain "W". If it does, then multiply A1 by A2, otherwise return zero. You could nest another IF that explicitly checks if A3 contains "L" and then return zero. The question that remains then is what should be show when A3 doesn't contain either "W" or "L". I.e. when it's empty or contains something else.