Excel: Nested IF statement with INT formula within

[Gymnast14]

Hi,
I need help writing a nested IF statement with a formula within the statement...if that makes sense. Here is what I'm trying to do, in english:

If cell = 0, then calculate =INT((Date2-Date1)/7), if the formula result is greater than 25, then 1, else 0.

Is this even possible? Thanks in advance for any help!

 

[SkipVought]

Hi,
[tt]
=If(cell=0,If(INT((Date2-Date1)/7)>25,1,0),WHAT???)
[/tt]
you spicified what happens if cell=0, which is If(INT((Date2-Date1)/7)>25,1,0) but that is cell<>0???



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Gymnast14]

The "WHAT???" will be a 0. Sorry I didn't specify that. THANK YOU so much for your help! The formula works perfectly.