G
Guest
i am using the If function, but i wish to expand the logical test criteria.
I had three names that the cell could not equal, and previously did this by
using three *AND(not = to)* instructions. Now however this has expanded to
over a hundred names that i want the target to not equal.
short of writing out 100 more AND commands in the if function how can i
achieve this?
The list of names i want to exclude are in the same excel file - could i
perhaps link the if function to the table?
any help greatly appreciated
thanks
I had three names that the cell could not equal, and previously did this by
using three *AND(not = to)* instructions. Now however this has expanded to
over a hundred names that i want the target to not equal.
short of writing out 100 more AND commands in the if function how can i
achieve this?
The list of names i want to exclude are in the same excel file - could i
perhaps link the if function to the table?
any help greatly appreciated
thanks