IF statement to return 0 if 0 in cell if not return formula

Well you can see that the TRUE action for the second IF statement is:

(F7-C7)/C7

which should give you -5.26%, so there is something about the comparison

C7>=1

that is giving you the FALSE action.

Are you sure you have typed it correctly?

Pete