Hi Rick,
I've had another look at this and found it's the cell being formatted for
"text" rather than "general" that's the issue. The expressions work when I
reformat the cell to general.
Many thanks for all your inputs.
Steve Sharpe.

"Rick Rothstein" wrote:

Can you describe "doesn't work" for us? What did you have in the cells, what
did the formula produce and what did you think the formula should have
produced? Telling us that would be far more helpful than just saying
"doesn't work".

--
Rick (MVP - Excel)


"Struggling in Sheffield"
wrote in message ...
Hi,
Sorry but this doesn't work.

"xlmate" wrote:

does this do what you want

=IF(OR(F3="",G3=""),"",IF(F3G3,"Yes",IF(F3=G3,"Eq ual",IF(F3<G3,"No"))))

if any of the cells are blank, it will remain blank.

HTH

--
Pls provide your feedback by clicking the Yes button below if this post
have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis



"Struggling in Sheffield" wrote:

Hi,
I have a simple nested IF function (Excel 2003) which compares numbers
in
two cells, then returns a word depending on whether one number is
greater
than, equal to, or less than the other:

=IF(F3G3,"Yes",IF(F3=G3,"Equal",IF(F3<G3,"No")))

Either (or both) of the compared cells might contain the number 0
(zero) in
which case I want the IF function to display the appropriate word.

However if the compared cells are blank (have no data in them), my
unsophisticated IF function thinks that F3=G3 and returns the word
"Equal".

How can I get the IF function to remain blank when my compared cells
(F3 &
G3) are blank?

Cheers,
Steve Sharpe.