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