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:
But I need to cap that 200% at 120%; where would I put my MAX at?
Aucun commentaire:
Enregistrer un commentaire