I am trying to create one formula that will do this: If <=10, then take 50% of the amount, if >10, then the lower of 5 or 25% of the amount.
I converted the second statement to Excel by saying if >20, then 25%, otherwise 5.
Is there any way to combine these two statements?
=ROUNDUP((IF(E33<=10,E33*0.5,0)),0)
=ROUNDUP((IF(E33>20,E33*0.25,5)),0)