LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ignore blank cells Angyl Excel Discussion (Misc queries) 4 October 30th 07 09:42 PM
Can a formula ignore empty cells? Melissa Excel Worksheet Functions 1 March 31st 06 06:24 PM
Trendline to ignore empty cells Kara Charts and Charting in Excel 0 June 9th 05 05:39 PM
Trendline to ignore empty cells Kara Charts and Charting in Excel 2 June 7th 05 05:30 PM
Trendlines to ignore empty cells Hoochi Coochi Man Charts and Charting in Excel 7 January 14th 05 01:31 PM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"