ozbeachbum
Board Regular
- Joined
- Jun 3, 2015
- Messages
- 161
- Office Version
- 2021
- Platform
- Windows
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.
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.