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

C7 and F7 are numeric Pete

Hope this helps

Thanks
CraigieL

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

Hi Pete

Yes using the formula as processed

IF(AND(C7=0,F7=0),0,IF(C7>=1,(F7-C7)/C7,F7/F7))

But works if cells are 0 but not with values

Thanks
CraigieL

Well, all I can suggest is that you post the workbook here, so I can see what is going wrong.

Pete