Adding an another IF(AND) isn't working

[tsakta13ole]

Hi. I'm attaching my workbook if you could take a look. When mod(row(),2)=0,B38<>'' I want (LOOKUP(B38+16,$P$4:$P$11,$P$5:$P$12)-B38)/365 and when mod(row(),1)=1 and B38<>"" I want F37-(B38-B37)/365), at all the other options I want blank. I tried adding an another if(and(mod(row(),2)=1,b38<>"'),F37-(B38-B37)/365 to the following formula but it doesn't work.

IF(AND(MOD(ROW(),2)=0,B38<>""),(LOOKUP(B38+16,$P$4:$P$11,$P$5:$P$12)-B38)/365,F37-(B38-B37)/365)

Thanks for any help!



RSX DATA28.xlsm

[protonLeah]

Please Login or Register  to view this content.

[newdoverman]

I think that this might be what you are looking for:

Please Login or Register  to view this content.

You have mod(row(),1)=1 this doesn't return a value of 1. It will always return 0. I made the assumption that you meant IF(MOD(ROW(),2)=1 was what you meant.

[tsakta13ole]

Thanks to both! Both work.