Help with formula

[OTT]

I have the following formula in my spreadsheet:

=IF(AND(ISNUMBER(N2),M2=""),NETWORKDAYS(AV$2,N2,AY$2:AY$13),"")

amoung other things it looks at column M and if it's blank then the formula generates a number. I now want it to look at column M and if it's blank I want it to then look at column X and if that's also blank then I want it to generate a number. If either column m or column X has an entry in it I don't want a number to be generated.


Can anyone tell me what changes I have to make to my formula to include this please?

 

[m.k.johnson86]

Try

=IF(AND(ISNUMBER(N2),M2=""),IF(AND(ISNUMBER(N2),x2=""),NETWORKDAYS(AV$2,N2,AY$2:AY$13),""),"")

 

[OTT]

That works. Thank you!

 

[zookeepertx]

Just a thought to maybe have the code be a tiny bit shorter, try:

=IF(AND(ISNUMBER(N2),M2="",X2=""),NETWORKDAYS(AV$2,N2,AY$2:AY$13),"")

It works here on a very small test sheet anyway...