Ok, I'm going to try to be as specific as possible, but I'm racking my brain over an excel formula I can't figure out. What I'm trying to accomplish is to have one of three things populate based on a few variables in other cells.

Basically, what I want it to do is :

If L1 is > 0 and J1, N1, and P1 is 0, then populate the Cell with "silver".

If J1, N1, or P1 is more than 0, populate with "low".

Unless V1 is less than 50, in which case populate with "High".

I have gotten close a few times, but ultimately I can't figure it out and have been at it for several hours. Any help would be greatly appreciated!


You'll want to structure your IF formula based on which scenarios take priority.

=IF([first scenario], [first scenario value], IF([second scenario], [second scenario value], IF([third scenario], [third scenario value])))

In your case, it would be the following:

=IF(AND(L1>0, J1=0, N1=0, P1=0), "Silver", IF(V1<50, "High", IF(OR(J1>0, N1>0, P1>0), "Low")))