Using a data validation AND an IF formula in the same cell [Solved/Closed]

Posts
2
Registration date
Friday April 5, 2013
Last seen
April 5, 2013
- Apr 5, 2013 at 08:40 AM - Latest reply:
Posts
2
Registration date
Friday April 5, 2013
Last seen
April 5, 2013
- Apr 5, 2013 at 09:21 AM
hi, I have a spreadsheet in excel 2010 where one of my columns uses a dropdown list using the 'data validation' function.
The list details several payment methods. Certain customers always use the same payment method, so I had planned to use an IF formula to autofill the field with a particular payment method to save me time.
For example, Mr Smith always pays by Direct Debit.

However, even though 'direct debit' appears in the drop down list I have made, Excel wont let me input the formula in that cell...

Is there any way around this?
thanks for your help
See more 

1 reply

Best answer
Posts
2
Registration date
Friday April 5, 2013
Last seen
April 5, 2013
- Apr 5, 2013 at 09:21 AM
6
Thank you
!!!
I fixed it!!!

just thought I would put it here incase anyone else is wondering

basically, all I had to do was make sure the conditions were in place for the IF formula to be activated, when I input the formula.

so, if Mr Smith always pays by direct debit, and direct debit appears in my validation list, Excel let me put the If formula in as long as I made sure the row I was inputting it into was a row where Mr smith was paying by direct debit.

that was a terrible sentence, I hope it made sense

Thank you, bite_tony 6

Something to say? Add comment

CCM has helped 1675 users this month