Actually, you also need to remove the second AND, and you can get rid of some of the brackets, like this:
Formula:![]()
IF(AND(C7=0,F7=0),0,IF(C7>=1,(F7-C7)/C7,F7/F7))
Hope this helps.
Pete
Actually, you also need to remove the second AND, and you can get rid of some of the brackets, like this:
Formula:![]()
IF(AND(C7=0,F7=0),0,IF(C7>=1,(F7-C7)/C7,F7/F7))
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks