mercredi 8 août 2018

Excel Data Validation - How to validate a cell using IF function after a Yes/No droplist menu?

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