lundi 29 octobre 2018

Need to ignore zeroes in IF statement

Hi i have two columns (D and E) both contain data - both include zeroes in them.

I am looking to write an IF statement categorizing whether there is "Growth" or "decline" over these two columns as one is FY17 and the other is a re forecast. However, I need to ignore the zeroes in both theses columns

Any help would be greatly appreciated.

Aucun commentaire:

Enregistrer un commentaire