Help with nested IF

[tojomojo]

I am trying to test a cell ad see if it is blank and if it is return a blank the target cell. If it isnt blank I want the rest of the statement to run.

My syntax is wrong somewhere.....

IF(C4 = "","",(OR(AND(TODAY() <> E4,F4="Complete"),AND(TODAY() < E4,F4="In progress")),LOOKups!$D$2,LOOKups!$D$3))

???Thanks

 

[steve the fish]

If you need to do two IF tests then you need two IFs.

=IF(C4 = "","",IF(OR(AND(TODAY() <> E4,F4="Complete"),AND(TODAY() < E4,F4="In progress")),LOOKups!$D$2,LOOKups!$D$3))

 

[Tim_Excel_]

IF(C4 = "","",(OR(AND(TODAY() <> E4,F4="Complete"),AND(TODAY() < E4,F4="In progress"))))

This is one formula, the rest is not included.

If you want a nested formula, you could use IFS() (if your Excel version allows for it).

IFS(test1, value, test2, value, test3, value...)

Otherwise, you are missing a second (nested) IF() function within the IF() function you already have.

e.g.

IF(C4="","",IF(OR(AND(TODAY() <> E4,F4="Complete"),AND(TODAY() < E4,F4="In progress"))=TRUE,[COLOR=#333333]LOOKups!$D$2,LOOKups!$D$3))[/COLOR]

 

[tojomojo]

That works well and does not populate the target field if C4 is blank - thanks........but it only ever display $D$2 now even if TODAY() < E4. I need this to input $D$3 into the target cell

 

[Tim_Excel_]

IF(OR(AND(TODAY() <> E4,F4="Complete"),AND(TODAY() < E4,F4="In progress"))=TRUE,LOOKups!$D$2,LOOKups!$D$3)

Let me deconstruct the formula for you

IF(test, value if test = true, value if test = false)
[COLOR=#ff0000]OR([/COLOR][COLOR=#0000cd]AND([/COLOR]test1,test2[COLOR=#0000CD])[/COLOR], [COLOR=#008000]AND([/COLOR]test3,test4[COLOR=#008000])[/COLOR][COLOR=#ff0000])[/COLOR] 'if either test1 and test2 are true, or if test3 and test4 are true

So, in what I wrote, you check if either TODAY() <> E4 and F4="Complete", or if TODAY() < E4 and F4="In progress"
If either of these is true, then you want the value from LOOKups!$D$2
If neither are true, then you want LOOKups!$D$3

 

[tojomojo]

Thanks. Got it now. I also had a cell referenced wrong. All good......

 

[Tim_Excel_]

Glad to have helped