mardi 30 octobre 2018

Adjusting IF formula to include negative figures

I have two columns - Column D is a forecast and Column E is historical data

I have the following IF statement:

=IF(OR(D42=0,E42<=0),"",IF(D42>E42,"Organic Growth","Organic Decline"))

However, I need to show that even the following is "Organic Decline" but my current formula doesn't account for these:

enter image description here

Aucun commentaire:

Enregistrer un commentaire