If Function

Closed
Jen - Feb 5, 2015 at 07:47 PM
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - Feb 6, 2015 at 06:43 AM
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?


Related:

1 response

vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
Feb 6, 2015 at 06:43 AM
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.
0