Nested Ifs, adding another nest but impacting different cell

[seanpears99]

Hi all

I have a table (shrunk down)

risks.JPG

I have a formula in column L:-

=IF(K3<>"",IF(K3>=17,"Reportable","Available for Override"),"")

However I want to allow the user to select a Yes value from column M to override the scoring validation and turn the value in column L to reportable so I can then pick it up for a vba report and ave run out of brain power.Any ideas how I alter the above formula so I can incorporate this?

Man thanks
Sean

[Aardigspook]

Try adding it in an OR statement:

=IF(K3<>"",IF(OR(K3>=17,M3="Yes"),"Reportable","Available for Override"),"")