Airtable Nested IF/AND project

I need someone who is comfortable in airtable doing nested and/if statements. For example, if this field > that field AND this field is < this field, YES, otherwise NO, type situations. I have 4-5 variations I need which for someone who knows these statements could probably be knocked out quickly.

BONUS if we can get this done ASAP!