You are my luminary Biff!
Thanks,
See, one does learn by attempting replies :)


| You don't need AND. It's not doing anything!
| =IF(AND(A2="Laptop Display"),10,IF(AND(A2="Desktop Display"),20,""))
| =IF(A2="Laptop Display",10,IF(A2="Desktop Display",20,""))
| AND is used to check multiple conditions:
| =IF(AND(A2="Laptop Display",B2="Desktop Display"), TRUE,FALSE)
| Biff