If you got an error it is presumably because you tried to type in the
formula (and got it wrong) instead of copying the formula from the newsgroup
and pasting it into the formula bar.
The change you made to the formula is the reason why you got FALSE returned.
The original formula given by Pete_UK was correct.

[Note also that if you want help it isn't much good just saying "... and
error was indicated ...".
You'd need to tell us what the error message was.]
--
David Biddulph

"Fred Golfer" wrote in message
...
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