Forum Discussion
=IF function nesting
Hello Julian,
In the attached file, the formula in J4, copied down rows and across columns, is:
=CHOOSE(MATCH($F4,{"Monthly","Quarterly","Yearly"}),
(J$3>=$H4)*(J$3<=$I4)*$G4,
(J$3>=$H4)*(J$3<=$I4)*$G4/3,
(J$3=$I4)*$G4)Note the following references for revenue recognition:
1. Over time = IFRS 15, pars. 35-37; and
2. At a point in time = IFRS 15, par. 38.
Cheers!
Twifoo
Twifoo , Hi, thanks for responding.
You are correct - the timing of services is a little complex so for the modelling I have made the assumptions you have identified.
Regards
Julian
Hello Julian,
In the attached file, the formula in J4, copied down rows and across columns, is:
=CHOOSE(MATCH($F4,{"Monthly","Quarterly","Yearly"}),
(J$3>=$H4)*(J$3<=$I4)*$G4,
(J$3>=$H4)*(J$3<=$I4)*$G4/3,
(J$3=$I4)*$G4)
Note the following references for revenue recognition:
1. Over time = IFRS 15, pars. 35-37; and
2. At a point in time = IFRS 15, par. 38.
Cheers!
Twifoo
Twifoo , Hi. Thank-you for that. I've implemented it and it works perfectly. Thank-you also for the references to the Revenue Recognition standards - as is the case in many instances how we recognise income for the internal (sales) team, and the income brought to account for accounting/tax can be 3 different things unfortunately!
Regards and thaks again.
Julian
- You’re very much welcome!