Forum Discussion

MikeY's avatar
MikeY
New Member
10 years ago

IF - OR Formula When Dealing with Null

Hello,   I have columns "M2 Fail", "M3 Fail", "M4 Fail", etc.  1 means fail, 0 means pass.  The data for "M2 Fail" is pulled from Month 2, "M3 Fail" from Month 3, etc.   Right now, an input in nu...
Need Help
Tutorial Requests
BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
10 years ago

Hi MikeY

 

You can write the below formula in your calculated column to achieve your desired result.

 

For M2 Fail= IF(AND(ISBLANK('Month Problem'[Month 2])=TRUE(),'Month Problem'[Month 1]>0),1,0)

For M3 Fail=IF(AND(ISBLANK('Month Problem'[Month 3])=TRUE(),'Month Problem'[Month 2]>0),1,0)

For M4 Fail= IF(AND(ISBLANK('Month Problem'[Month 4])=TRUE(),'Month Problem'[Month 3]>0),1,0)

 

Hope this will help you sir.

 

Thanks & Regards,

Bhavesh