I have this formula:
=IF(C7="","",IF(C6>C5,IF(C7<=C5,0,(C7-C5)/(C6-C5)),IF(C6<C5,IF(C7>=C5,0,ABS(C7-C5)/(C5-C6)))))
referencing these cells:
Formula is a little confusing to the average person, however it gets me what I'm looking for. Is there any way to simplify this?

Aucun commentaire:
Enregistrer un commentaire