How to create a formula but only if it doesnt match any entries in another column

Hi All,

I have large spreadsheet with many formulas. but now I want to update the sheet so some of those formulas will only be calculated if the any of the entries from a column in another tab are not matched.

This is the formula I use (apologies, I'm a novice so there is probably a better way).

=IF(OR(F2="Alan",F2="Amy",F2="Bob"),"",IF(AND(ISNUMBER(K2),ISNUMBER(X2)),K2*0.1207-X2,IF(AND(ISNUMBER(K2),X2=""),K2*0.1207,IF(AND(K2="",ISNUMBER(X2)),-X2,IF(AND(K2="",X2=""),"")))))

so this checks is cells are numbers and and names are not Amy, Alan or Ben

sample data
1.png

But the more names I need to add the longer the formula gets.
Is there a simpler way to do this excluding names in a column on another tab?

thank you

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

Try to create the list of excluding names in other column, i.e, AR
Then in AP2:

Please Login or Register  to view this content.