Both teams to score

Hi All

need help with some a formula using data from a the following table

head col1 head col2 head col3 head col4
Manchester Utd Arsenal 2 1
Chelsea Reading 0 0
Wigan Aston Villa 1 1
Westham Man City 2 0

I would like a formula that would indicate a 'Y' if both teams have scored

I tried the following but get only 'Y' irrespective if one team did not score nor two teams did not score

=if(e2>0&f2>0,'Y','')

Thanx in anticipation for all help

Regards

Raj

How about:

Please Login or Register  to view this content.