If/OR Formula Help

[ghp2017]

Hello,
I need help with a formula. Somehow I have to add something like '=IF(I5<>"",1,0)' to the formula below.
=IF(OR(E5=0,F5=0,F5<E5),FALSE,AND(F5>=E5)*IF(OR(F5<=E5+3),1,0))

I just can't seem to get it to work.

Thanks,
George

 

[kweaver]

I don't think you need the AND and the 2nd OR.

=IF(OR(E5=0,F5=0,F5<E5),FALSE,(F5>=E5)*IF(F5<=E5+3,1,0))

Where do you want the additional IF condition?

 

[ghp2017]

I don't think you need the AND and the 2nd OR.

=IF(OR(E5=0,F5=0,F5<E5),FALSE,(F5>=E5)*IF(F5<=E5+3,1,0))

Where do you want the additional IF condition?

It doesn't matter as long as it works. But logically it should come after the E/F check. LOL!!

 

[kweaver]

Could you mean:

=IF(OR(E5=0,F5=0,F5<E5),FALSE,AND(IF(I5<>"",1,0),F5>=E5)*IF(F5<=E5+3,1,0))

 

[ghp2017]

Could you mean:

=IF(OR(E5=0,F5=0,F5<E5),FALSE,AND(IF(I5<>"",1,0),F5>=E5)*IF(F5<=E5+3,1,0))

This doesn't give the expected result.

 

[Fluff]

It would help if you could post some example data (using the XL2BB add-in), along with expected outcome.
An explanation of how you got to the outcome would also help.

 

[ghp2017]

It would help if you could post some example data (using the XL2BB add-in), along with expected outcome.
An explanation of how you got to the outcome would also help.

Column E = Opportunity Create Date
Column F = Opportunity Sold Date
Column I = Days Since Last Activity (aka they entered a logged call)

I am trying to create a formula that would give me:

• "FALSE" if Column I, Column E & Column F are all blank
• "1" if Column I is not blank OR Column F is within 3 days of Column E
• "0" if Column I is blank AND Column F is NOT within 3 days of Column E
• "0" if Column I is blank AND Column F is earlier than Column E

 

[Fluff]

Ok, maybe

=IF(AND(E5="",I5="",F5=""),FALSE,IF(OR(I5<>"",AND(F5>=E5,F5<=E5+3)),1,0))

 

[ghp2017]

Ok, maybe

=IF(AND(E5="",I5="",F5=""),FALSE,IF(OR(I5<>"",AND(F5>=E5,F5<=E5+3)),1,0))

That didn't work either. I may just have to split it up

 

[Fluff]

In what way didn't it work?