If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Nested IF that will ignore blank (empty) cells
Hi,
Thanks for your help, I couldn't get it to work at first as the cell was formatted for "text" and not "general", so it thought I was entering text and not a function. I don't call myself 'Struggling in Sheffield' for nothing. Thanks again. "xlmate" wrote: does this do what you want =IF(OR(F3="",G3=""),"",IF(F3G3,"Yes",IF(F3=G3,"Eq ual",IF(F3G3,"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(F3G3,"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 | |
Display Modes | |
|
|