Excel Formula Help

Question

I am having a problem with a formula designed to calculate a commission rate that is taking 30% of the gross revenue. There is a minimum amount of $50 if the gross revenue is $50 or less. My formula is calculating properly, but putting in a value of $50 for all cells where the gross revenue has not been entered. I need this to be zero until an amount is entered into the gross revenue column.

How can I edit the formula to show zero (or leave blank) until data is entered in column Q? This should be an easy fix, but I am drawing a blank? Thank you for your help!!

riny_van_eekelen · Answer

ederdzinski&nbsp;Try this.=IF(AND(NOT(ISBLANK(Q11)),Q11&lt;=50),50,Q11*0.3)and copy down.&nbsp;

ederdzinski · Answer

Thank you for your help!&nbsp; I am still seeing 50 in column S.&nbsp; Could that be caused by the formula in column Q that is subtracting revenue from expenses?&nbsp;&nbsp;&nbsp;Riny_van_Eekelen&nbsp;

ederdzinski · Answer

I also see that the minimum value of $50 wasn't calculating properly.&nbsp; I changed the formula using the MAX function, but still receive the value of 50 when no data is populated in column Q (which does have a formula subtracting values in column P from column O).&nbsp;&nbsp;&nbsp;ederdzinski&nbsp;

msiva · Answer

Hi&nbsp;ederdzinski,&nbsp;Please try this formula in column Q:&nbsp;=IF(OR(ISBLANK(Q15),(Q15=0)),50,Q15*0.3)&nbsp;&nbsp;

msiva · Answer

* formula in column S (not column Q), sorry 🙂

Forum Discussion

Excel Formula Help

8 Replies

Resources