I'm using an IF formula to increase a set quantity by 30% if the selected cell is less than 0, as per the example below.
=IF($AN4<0,MROUND(Z4*1.3,1),0)
What I need in addition to this formula is that the resulting value, once increased by 30%, should not exceed 50. I don't know how to extend this formula can anyone please help?
Bookmarks