Using a data validation AND an IF formula in the same cell
Solved/Closed
bite_tony
Posts
2
Registration date
Friday April 5, 2013
Status
Member
Last seen
April 5, 2013
-
Apr 5, 2013 at 08:40 AM
bite_tony Posts 2 Registration date Friday April 5, 2013 Status Member Last seen April 5, 2013 - Apr 5, 2013 at 09:21 AM
bite_tony Posts 2 Registration date Friday April 5, 2013 Status Member Last seen April 5, 2013 - Apr 5, 2013 at 09:21 AM
Related:
- Multiple if statements in excel data validation
- Transfer data from one excel worksheet to another automatically - Guide
- Using multiple if functions with data validation - Excel Forum
- How many if statements can you nest - Guide
- Excel data validation list from table multiple columns - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
1 reply
bite_tony
Posts
2
Registration date
Friday April 5, 2013
Status
Member
Last seen
April 5, 2013
9
Apr 5, 2013 at 09:21 AM
Apr 5, 2013 at 09:21 AM
!!!
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
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