Nesting OR/AND/IF issue

[Fursmanm]

I want to return "None" if two conditions are met.

Condition 1: =IF(AND(ISERROR(DQ6),B6<>"Not Found"),"None","")

i.e if DQ6 is Error, AND B6 does NOT equal "Not Found", then return None.

This formula works fine.

Condition 2: However, i want to ALSO return "None" if the sum of a range is equal to 0.

=IF(SUM(CY6:DQ6)=0,"None","")

again this works.

However, im struggling to nest the two formula into a single cell?

Summary:

If DQ6 is Error, AND B6 does NOT equal "Not Found", then return "None". Also return "None" if sum of a range is 0.

Help!

Regards,

Mike

[Pepe Le Mokko]

Perhaps

Please Login or Register  to view this content.

[Fursmanm]

thanks for help but your solution doesnt seem to work,

works for the sum part, but it returns N/A if cell DQ6 is an error, rather than returning "None"

[Fursmanm]

thanks for help but your solution doesnt seem to work,

works for the sum part, but it returns N/A if cell DQ6 is an error, rather than returning "None"

[oeldere]

Then try this one.

Please Login or Register  to view this content.

[Fursmanm]

That didnt work either! but thank you for trying!

I have actually figured it out now, i switched the two conditions round so it deals with the N/A values first, otherwise it was returning N/A straight off the bat.

If anyones reading this in like 5 years time (i seem to find myself reading 5 year old threads a lot at the moment!) a working formula is:

=IF(AND(ISERROR(DQ5),B5<>"Not Found"),"None",IF(SUM(CY5:DQ5)=0,"None",""))