View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Struggling in Sheffield[_2_] Struggling in Sheffield[_2_] is offline
external usenet poster
 
Posts: 66
Default Nested IF that will ignore blank (empty) cells

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.