Nested IF ?

[StellaArtois]

Hi all,

I am having a little difficulty working out a formula

I have B11 which has a number of absences and B12 which has a number of lateness

I am trying to have a list of absences based on B11 and B12

I am looking for a list based on B11 and B12

=IF(I25<=$B$11,"ABSENCE - 1",IF(J25<=$B$12,"LATENESS - 1"))
This is where i have got so far

I was planning to drag this down and have instances 2,3,4 ryc based on B211 then start listing B12 Lateness 1,2,3,4 etc

Thanjks for any help

 

[Sergius]

It would be easier if you provided a fragment of your data (without confidential data). In this case, the solution will be faster.