Multiple IF's query

[Gaurang Mhatre]

Dear Friends,

Got bit query on multiple ifs in the attached excel file as the criteria which i am looking for unable to get it by if function.
Please look into it once you get time and also provide a solution.

Thanks in advance for the help as always

Regards,
Gaurang.

 

[azumi]

In E6 and copied down:

=IF(AND(C6=0,D6="NA"),0,IF(AND(C6="NA",D6="NA"),"NA",SUM(C6:D6)))

 

[Gaurang Mhatre]

Hi Azumi,

I tried this IF(AND(C6="NA",D6="NA"),"NA" but still it is showing 0 instead of NA. Rest condition is working fine. but when there two NA then it should give NA rather than 0. Any idea why it is showing 0 when there are NA in both the columns.

Thanks in advance.

Regards,
Gaurang

 

[Hui]

E6: =IF(AND(C6=0,D6="NA"),0,IF(COUNTIF(C6:D6,"NA")>=1,"NA",D6+C6))
Copy down

 

[Gaurang Mhatre]

@ hui: thanks boss...
@azumi : thanks to u as well....

Problem solved.
God bless..

Regards,
Gaurang