Using IF formula for multiple crieteria and hiding #N/A in Formula cell

**sanjeevkumarmc** · 10-10-2012, 10:02 AM

Hi,

My query is, I am giving formula in R4 and the formula is =IF(AND(C4<>"",S4<>""),"PAID","NOT PAID")

I have to give one more crieteria in R4, where in, if C4 is BLANK, R4 should reflect BLANK and my R4 should not show #N/A since it contains formula and no value in corrsponding cell that is C4.

Please help immediately.

Regards,
Sanjeev

**Moo the Dog** · 10-10-2012, 10:07 AM

Will this work:

Formula:

Please Login or Register  to view this content.

**sanjeevkumarmc** · 10-12-2012, 12:43 AM

Its working absolutely fine!

Thanks for the quick reply!!

**Moo the Dog** · 10-12-2012, 01:01 AM

You're welcome!

Using IF formula for multiple crieteria and hiding #N/A in Formula cell

LinkBack

Thread Tools

Rate This Thread

Display

Using IF formula for multiple crieteria and hiding #N/A in Formula cell

Re: Using IF formula for multiple crieteria and hiding #N/A in Formula cell

Re: Using IF formula for multiple crieteria and hiding #N/A in Formula cell

Re: Using IF formula for multiple crieteria and hiding #N/A in Formula cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions