Ignore empty cells in an IF formula

**moppyau** · 07-09-2013, 05:26 AM

Hi All,
Attached is a simplified worksheet that I'm having trouble with. Basicly I want to know if it possible for excel to ignore blank cells in an IF formula?
Thanks in advance

**Ace_XL** · 07-09-2013, 05:29 AM

Try

=IF(AND(D1="",F1="",),0,IF(D1>F1,4,IF(D1=F1,2,0)))

**moppyau** · 07-09-2013, 05:44 AM

Thanks for your help Ace but I'm still getting an answer of 2 when i remove the numbers in D1 & F1

**moppyau** · 07-09-2013, 05:51 AM

Oops resent same message.

**elayaz** · 07-09-2013, 06:29 AM

Hi..

Try this.

=IF(OR(D1="",F1=""),0,IF(AND(D1="",F1="",),0,IF(D1>F1,4,IF(D1=F1,2,0))))

**elayaz** · 07-09-2013, 06:33 AM

Sorry forgot to delete the repetition. This itself should work

=IF(OR(D1="",F1="",),0,IF(D1>F1,4,IF(D1=F1,2,0)))

**moppyau** · 07-09-2013, 06:42 AM

Thanks elay that works a treat.

Ignore empty cells in an IF formula

LinkBack

Thread Tools

Rate This Thread

Display

Ignore empty cells in an IF formula

Re: Ignore empty cells in an IF formula

Re: Ignore empty cells in an IF formula

Re: Ignore empty cells in an IF formula

Re: Ignore empty cells in an IF formula

Re: Ignore empty cells in an IF formula

Re: Ignore empty cells in an IF formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions