jeudi 16 septembre 2021

How could this IF formula me simplified? If possible

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:

enter image description here

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