Modifying the result of an IFs formula based on whether another cell is filled.

Waiting on OP

Hello. Right now I'm using the following simple formula.

=IFs(S20="X",-3,O20="X",-2,L20="X",-1,H20="X",0,H20="",0)

And I'm trying to add a condition where if another box is filled with an X, it takes the result if the IFs statement and subtracts an addition -1.

Any advice on how to do this?

Posted May 7, 2025, 2:32 PM UTC

16
Loading comments…