The issue is quite simple, and I have seen that it is maybe possible to do it using VBA, but I am quite confident it is also possible to do using just data validation.
I have a Yes/No dropdown list in Column A, and I would like to display "0" if "yes", or be able to insert the number (e.g. 3200) if "no", in Column B.
A B
yes 0
No 3200
yes 0
I tried customizing data validation using IF function:
=IF($A1="Yes", "0", "")
but in that way I cannot insert a number on the cell.
Any comments will be appreciated.
Aucun commentaire:
Enregistrer un commentaire