Say I have a B60 and C60 cells which are both checkbox.
I only need three results,
- If B60 is true
- If B60 isn't true.
- If B60 and C60 are true.
I tried using
=IF(B60=TRUE,"B60 is true",AND(C60=TRUE,"Both B60 and C60 are true")
how can i fix this
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…