IF cell zero, DATEDIF/12

[ozbeachbum]

Apologies for there being no Mini Sheet, even with all the help from members, does not look like there is a solution to the issue.

I have the following formulae which I need to include an IF statement and both in the one formula;

(1): DATEDIF(P88,'[01 REGISTER holding co.xlsx]Holding Company List'!N88,"M")/12
(2): DATEDIF(P88,$P$57,"M")/12

IF(J88>0,(1),(2)

Individually 1 & 2 give me the correct answer, however I have been unable to work out how to combine them with the IF statement.
Any assistance greatly appreciated.
Cheers,
Dave.

 

[jdellasala]

I'm not clear on the problem, but the first problem I see is "IF(J88>0,(1),(2)". The formula should be

=IF(J88>0,1,2)

No need for all those parenthesis. And (1) can't be a named range, so it's unclear what the formula is supposed to be.

And why use (the unsupported but I'm impressed you know it) DATEDIF instead of just subtracting the dates and dividing by 365 ( or 365.25!) and either rounding it or just using the INT of it?

Just asking!

 

[Dave Patton]

What part of your formula failed?
What values are in the referenced cells?
Try Formulas Formula Evaluate to see the results

=IF(J88>0,DATEDIF(P88,'[01 REGISTER holding co.xlsx]Holding Company List'!N88,"M")/12,DATEDIF(P88,$P$57,"M")/12))

 

[ozbeachbum]

Thank you so much, you made me realise that I had a parenthesis that was not needed.
=IF(J88>0,DATEDIF(P88,'[01 REGISTER holding co.xlsx]Holding Company List'!$N$88,"M")/12),DATEDIF(P88,$P$57,"M")/12)
Solved
=IF(J88>0,DATEDIF(P88,'[01 REGISTER holding co.xlsx]Holding Company List'!$N$88,"M")/12,DATEDIF(P88,$P$57,"M")/12)
To answer your question, the reason I am using DATEDIF is because my research indicated that it would return the time period as a decimal, which is what I was trying achieve at the time.
Thanks again,
Dave.

 

[ozbeachbum]

Thanks Dave,
As you can see jdellasala put me on the right track to your solution.
Cheers,
Dave.