Hi All,
I am looking to find out a formula that will allow me to calculate the below.
say for example I wanted to multiply a qty * a $ amount and for it to never exceed a certain number.
max amount $1160 so =SUM(24*$50) will equal $1200 but I want the result to be $1160.
No what the amounts to be calculated I dont want the amount to go over $1160.
thanks
Bookmarks