Hi!

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

"Rodney" wrote in message
...
Explanation:

The formula reads..
If a2="laptop display" give it a 10
If a2="desktop display" give it a 20
the AND's connect the formula query
if any of the queries returns a false reading eg:"Monitor Display"
then leave the cell blank (the two quotation marks at end.. "")

you can substitute the numbers to taste/requirements

HTH

=IF(AND(A2="Laptop Display"),10,IF(AND(A2="Desktop Display"),20,""))