Hi guys,
Im trying to do several things at the same time and I'm hoping you can help me figure this one out.
What I'm trying to do here is if a layaway has been paid off then there will be a tax amount in column C. IF there is tax in column C and column A has the word layaway (or the word way) in it then I need to find out how much the total of the layaway $ amount was. Meaning, to figure out how much the tax is for.
For example:
If the text in Column A contains the word way AND column C contains a $ amount then return the amount that the tax would be for.
Of course this would be an accumulated amount for all of column C.
So, if Layaway is in column A and $3.13 amount is in column C then it will return $50.00 as the original selling price.
Tax here is .0625 %
I'm not sure if I'm explaining this well enough so if not please ask me any questions you might have to help solve this one.
Bookmarks