Excel code, end function?

Joined
Nov 5, 2017
Messages
1
Reaction score
0
=IF(ISBLANK(A5),"",IF(AC5=2,"BACK",IF(AC5<2,"")))

I would like the function to complete after the first "Back" is activated. I have 24 other cells in the column and "BACK" keeps loading down the column as each cell reaches a certain value. I just want the function to stop after the first "BACK" enters
 
Back
Top