Tag Info

Hot answers tagged

2

Google has hidden the free option a bit. Regular edition of Google Apps is free for up to 10 team members.


2

The costs are absolutely nothing. By allowing PayPal to use your bank account, you are saving PayPal money - they don't have to pay your credit card company a transaction fee. That is the preferred mode of PayPal nowadays and they are doing their best to motivate people to finance their PayPal accounts with their bank accounts. From my point of view, I'd ...


1

Another way of doing it is by using the following formula. Formula =IFERROR(QUERY(A2:C8, "SELECT C WHERE B <=" & E2 & "ORDER BY C ASC LIMIT 1"),"") Explained The complete range is set to be the data range. The quasi SELECT statement first filters on items that are less or equal to the selected min qty. Then the items are ordered ascendingly ...


1

Actually, I figured this one out: =if(isblank(C3), "", VLOOKUP(C3, Prices!$A$2:$B$8, 2, true)) Where C3 is the quantity sold, and A2:B8 is the pricing chart range. 2 is the column index (1-indexed), which is in this case unit price (I took out the id column). The true indicates that my list is already sorted. I check if blank so that I don't have 0s all ...


1

You may have noticed that the first bullet points for 1. and 2. are the same - ie if goal is reached commission is 4%. So the difference is essentially between the second bullet points in each. If goal not reached, your choice, of the funds raised do you want to: keep and pay 9%? OR return and pay nothing?



Only top voted, non community-wiki answers of a minimum length are eligible