Dynamic Nested If Formula Use dependent on Cell Text

[IuneKeiki]

I have 3 categories (Priority, Less, None) that correlate to a specific NESTED IF Function but only differs in the percent within the calculation.
Overall, the result of the use of the formula provides a Status of behind, ahead, on track etc.

I currently have the status only populating with manual formula input, and I am trying to add it as an Add in, but that is also new to me and not working.
Is there a way to do this in a function, or am I stuck with using custom functions/Add ons and applying it as a user defined function?


Data is for multi lines but is basically:

Current Percent of FY Goal = CURRENT Cell $B$1
Percent of Goal Met = MET Cells in Column E ( $E1...)
Did not define names in excel (only here to make it easier to read)

Column A has the assigned text value of Priority, Less, None * I want this column to be modifiable but keep the same words.
"Priority" has a buffer zone of 5%
"Less" has a buffer zone of 10%
"None" has a buffer zone of 25%

IF(MET<=CURRENT-0.25,"BEHIND",IF(MET>=1,"COMPLETE",IF(AND(CURRENT+0.25>=MET, MET>CURRENT-0.25),"ON TRACK",IF(AND(1>MET,MET>CURRENT+0.25),"AHEAD"))))