Forum Discussion
Solved
Condition not working
Hi, I have attached the excel file wherein I want to have output as "1" in cell B5 in worksheet True. However, it is deriving the output as "2". The condition is that whenever the cell in row...
=IF(OFFSET(Demo!$B$3,-1,MATCH('True'!B$3,Demo!$B$3:$M$3,0)-1,,)="ACTUAL ",1,2)
Is this the formula you are looking for?
=IF(OFFSET(Demo!$B$3,-1,MATCH('True'!B$3,Demo!$B$3:$M$3,0)-1,,)="ACTUAL ",1,2)
Is this the formula you are looking for?
Thank you very much. This is exactly what I needed.