Reply to thread

Message: [QUOTE="Ssuzs, post: 3709063"] Sure! The vital information is this: Column E should be the TOTAL order amount (Cost+S&H+Tax) Column F should be the COST of the original item purchased (NO tax, NO s&H) Column G should be the COMMISSION EARNED for the transaction, which is 25% of the F (COST). So if someone purchases a product for 24.95 a. I need a formula that will calculate the commission, which in this case, should be 6.24 b. I need one that will calculate the TOTAL order amount. So 24.95+7.99 with 8.25% sales tax added to that sum. That total in this example should be 35.66 AND I AM A BIG JERK. It does work....THANKS BIFF!!!! I had my S&H entered as 6.95 and it is supposed to be 7.99. I AM SOOOO SORRY. But how do I apply that formula (=IF(F4="",0,ROUND((F4+7.99)*1.0825,2)) to all the transactions, not just the F4 transaction? [/QUOTE]