Forum Discussion
Solved
help with formula
I am sorry if this is simple but I just cannot figure it out. I have a drop down data column with three sizes, 4x6, 5x7, and 9x4 in column A. in column D my heading is "cards per sheet". If I select ...
I forgot 2 closing parentheses - sorry about that. The first formula should be
=IF(A2="4x6",20,IF(A2="5x7",16,IF(A2="9x4",15,"")))
But you have set up date validation for D2 that only allows the values 1, 2, ..., 10. So 20, 16 and 15 will be rejected.
I'd remove the data validation from D2. If you use a formula, data validation is not needed.
sure! There's no sensitive data. Just working out the basic spreadsheet.
https://1drv.ms/x/s!Ag5CIttUj0lyiolPe-WH_GyAh0ZDcg?e=76Ftg0
https://1drv.ms/x/s!Ag5CIttUj0lyiolPe-WH_GyAh0ZDcg?e=76Ftg0
I forgot 2 closing parentheses - sorry about that. The first formula should be
=IF(A2="4x6",20,IF(A2="5x7",16,IF(A2="9x4",15,"")))
But you have set up date validation for D2 that only allows the values 1, 2, ..., 10. So 20, 16 and 15 will be rejected.
I'd remove the data validation from D2. If you use a formula, data validation is not needed.
- That was it!!! Thanks so much! I honestly do not remember putting data values in D2. So much appreciate your help.