It's always the seemingly simple ones that stump me...!
Can anyone help with a data validation rule in cell B2, that restricts the value entered to less than 21, IF, cell A2 contains "Apples". Otherwise, the value entered should be less than 6 for any other value in cell A2?
Tried a basic =IF() statement, and various =AND() ones, but as usual...the formula escapes me.
Regards,
SiPH
Bookmarks