If Function Closed

Question

Hello, 
 
I'm having a bit of a trouble working the If Function in excel.
Here's my problem: My manager asked me to find the commission fees to charge and this is what he said he charges: either 2 percent of the purchase price or a flat fee of $25.00, which ever is greater. How can I determine this with the If Function if the purchase price was $35.83? How can I write this so that the IF Function can determine which one is right?


Configuration: Windows / Chrome 40.0.2214.111

vcoolio · Answer

Hello Jen,

Perhaps this formula may help:-

=IF(A2="","",IF(2%*A2<=25,25,IF(2%*A2>25,2%*A2)))

I'm assuming that the dollar values are in column A, starting in cell A2 with headings in row 1. So, copy the formula into cell B2 and drag it down as far as you need.

Format your cells to currency.

I hope this helps.

Regards,
vcoolio.

If Function

1 response

Similar discussions

Subscribe To Our Newsletter!