mercredi 6 janvier 2021

How can I use three conditions in a single cell? (IF+AND)

Say I have a B60 and C60 cells which are both checkbox. I only need three results,

  1. If B60 is true
  2. If B60 isn't true.
  3. 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

Aucun commentaire:

Enregistrer un commentaire