mercredi 15 septembre 2021

How to put a max return percentage on an IF function?

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

But I need to cap that 200% at 120%; where would I put my MAX at?

Aucun commentaire:

Enregistrer un commentaire