Just click in the formula bar to edit that formula, and change the *
back to a comma.

What error was indicated?

Pete

On Nov 5, 5:50*pm, Fred Golfer
wrote:
Thanks for the fast response. *When I tried it and error was indicated and
the formula slightly changed as follows:-
=IF(A3=0,"",IF(AND(A3=A4,A5<2)*1,"")) and the word "FALSE" was displayed.
Any idea what it could be??
Thanks again'
Fred Golfer



"Pete_UK" wrote:
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- Hide quoted text -

- Show quoted text -