Can you help me of the following formulas to my excel sheet?
Commission Column (Q)
If O is equal to or greater that H Multiplied by 45 and L is greater or equal to $300 then Q = 10% of K and L + 5% of M and N
Thanks in Advance
Can you help me of the following formulas to my excel sheet?
Commission Column (Q)
If O is equal to or greater that H Multiplied by 45 and L is greater or equal to $300 then Q = 10% of K and L + 5% of M and N
Thanks in Advance
can you post the formula that you have tried.
thanks
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Try
=iF(AND(O2>=H2*45,L2>=300),(K2+L2)*0.1+(M2+N2)*0.05,0)
Q2=if(and(o2>=h2*45,l2>=300),(k2+l2)*0.1+(m2+n2)*0.05,0)
Removed by JT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks