I'm trying to include a conditional however, I'm getting a sort of a
syntax error:

=if((F5H5) AND (UPPER(C7) = "YES") AND (C9/C10 H9), "Yes", "No")

The way to do logical AND in Excel is
AND(condition1, condition2, condition3)

So maybe this will meet the need:
=IF(AND(F5H5, UPPER(C7)="YES", C9/C10H9), "Yes", "No")

Or with an error check:
=IF(C10=0, "undefined", IF(...as above...))