Too many arguments using nested ifs

Hi.

I'm facing some difficulties completing the formula in column G (Answer). No matter how I try to write the formula I get "Too many arguments", so obviously I'm doing something wrong.

The formula I'm trying to complete is:

• If there's no text in corresponding cell in column C then calculate if value in F is higher than E, if higher write no and lower write Yes.
• If there's text in corresponding cell in column C then check value in corresponding cell in column F. If value is 0 or lower write yes, if value is higher than 0 write no.

See attached document for reference.

I tried two different variations, but same end result (Too many arguments).

Hoping it's an easy fix that I'm just too oblivious to see.

Thank you in advance.

Try this. In G2 then copy down

=IF(C2="",IF(F2>E2,"No","Yes"),IF(ISTEXT(C2),IF(F2<=0,"Yes","No"),""))