Multiple Conditional IF statement

[DRExcel515]

Here is a formula I am trying to build that basically states: If the current month value is (null) and the next month value is (null) then say "OKAY", but if the current month value is (null) and the second month value is <>(null) say "Current Month NA?" and if all of that is false (current month is a value basically) then pull back that value. For some reason I keep getting a FALSE. I tried using an If(and, IF(or etc. but all give me the FALSE. Any help would be much appreciated.

IF(INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$B3,'SQL Dump'!$A:$A,0))="(null)",IF(INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$A3,'SQL Dump'!$A:$A,0))="(null)","OKAY",IF(INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$B3,'SQL Dump'!$A:$A,0))="(null)",IF(INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$A3,'SQL Dump'!$A:$A,0))<>"(null)","Current Month NA?",INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$B3,'SQL Dump'!$A:$A,0))))))

Or:
IF(AND(INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$B4,'SQL Dump'!$A:$A,0)),INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$A4,'SQL Dump'!$A:$A,0)))="(null)","OKAY",IF(INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$B4,'SQL Dump'!$A:$A,0))="(null)",IF(INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$A4,'SQL Dump'!$A:$A,0))<>"(null)","Current Month Missing",INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$B4,'SQL Dump'!$A:$A,0),0))))

 

[cunningAce]

Re: Multiple Conditional IF statement help

Substitute the cell references to match your sheets and replace the ""(blanks) with "null"

A2 is the current month value
B2 is next months value

=IF(A2<>"",A2,IF(AND(A2="",B2=""),"Okay",IF(AND(A2="",B2<>""),"Current month N/A")))

 

[Special-K99]

Re: Multiple Conditional IF statement help

Try this

=IF(INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$B3,'SQL Dump'!$A:$A,0))="(null)",IF(INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$A3,'SQL Dump'!$A:$A,0))="(null)","OKAY",IF(INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$A3,'SQL Dump'!$A:$A,0))<>"(null)","Current Month NA?","XXX")),INDEX('SQL Dump'!D:D,MATCH('SD Calcs'!$B3,'SQL Dump'!$A:$A,0))
)

One scenario you havent catered for is when
current month is null and second month is not null, hence the XXX, amend as required.

 

[DRExcel515]

Re: Multiple Conditional IF statement help

Thank you guys very much! @Special-K99 that works great!