Try this:

=IF(A3=0,"",IF(AND(A3=A4,A5<2),1,""))

I think this is what you meant.

Hope this helps.

Pete


On Nov 5, 5:29*pm, Fred Golfer
wrote:
I have designed an excel golf score programme but I want to change how a
formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the
following conditions:-
if(A3=A4),and(A5<2) I want "1" or else a blank and if(a3=0) I want a blank.
Can anyone help please? I am using Excel 2003
Thanks,
Fred Golfer