|re: "The Questions!xx was referring to another tab in the spreadsheet"|
I know what a reference to another sheet looks like. That wasn't my point.
Everything I said in my earlier response still remains unresolved.
You still haven't asked Excel to compare H2 to anything.
Please spend a few minutes reviewing the Excel Help file for the IF function so you can at least understand how it is supposed to work.
AND(H4) means nothing to Excel.
Please spend a few minutes reviewing the Excel Help file for the AND function so you can at least understand how it is supposed to work.
If all you are doing is checking B14 for a value then the solution is a basic Nested IF:
=IF(B14<79, "SM", IF(B14<200, "MD", "LG"))
If H2 & H4 are somehow involved in this, you'll need to explain that to me, in words, not by trying to construct another formula.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.