IF/AND Formula

[MACGWEEDORE]

hi
having a problem with if/and formula

must show customers who purchases hardware and purchased over 200 euro's worth.

cells B5:B14 have codes H1 and S1, H1 = HARDWARE, S1 = Software
cells E5:E14 have values ranging from 500 to 20 euros

the formula i enter is if(and(B5="H1",E5>=200),"YES","NO")

all i get is "NO" all the time.
E5:E14 formatted as currency
B5:B14 i have tried formatting as text, general, number etc....
Please Please Please help doing my head in

[MarvinP]

Hi macgweedore and welcome to the forum,

I think you need to not put quotes around the H1 and in your formula.

Try that and see what happens.

[martindwilson]

that should work as long as b5:b14 haven't any spaces or other invisible characters in ,post a sample workbook