Assistance with Lookup and IF Formulas

Hey everyone, I am new here.

I am struggling with a formula and looking for some assistance please.

I am creating a quote and can't quite wrap my head around something.

I have the following parameters:

1. GST Exempt Y/N
2. PST Exempt Y/N
3. List of items - each item has a price and GST Yes/No and PST Yes/No

I am selecting an item from the list, adding the quantity. I need formulas to plunk in the unit price, GST calculation, PST calculation, and subtotal, taking into consideration the GST and PST exemption cells.

I am struggling with the GST and PST pricing using both the IF and the LOOKUP formulas. I'd love some assistance. Thank you!!!

Perfect thank you.

I think this is enough.

Essentially I need to check the following:
- Is it GST/PST exempt? Using Y/N
- I select an item from the list and using a LOOKUP formula check if the CHARGE GST/CHARGE PST column is Y/N
- Calculate the GST/PST using 5% or 6% depending on the cell

I'm struggling to get the two formulas combined together

I have been using *.05 and *.06 in the file for charging taxes, but can change that if needed to create a cell with the percentages and then multiplying the cells.

Thank you!

See if this helps

Formula:

Please Login or Register  to view this content.

My bad, thought I had deleted the reference formula.

Thank you, that works for part of it, but what I am struggling with is using the list - some items are charged taxes and some are not. So not all items are charged the 5%.

I can't quite seem to get the formula correct.

I edited the spreadsheet a bit to give more detail.

I didn't put enough information, sorry. I got hung up on the least amount of info as possible.

I've just re-uploaded explaining exactly what I need. Apologies if it's a lot of information.

Hahaha yes it is confusing, darn those tax exemptions!!!

Ahhh thank you. I see where I went wrong - I was still referencing a set range and not columns in general, as well as adding an extra ( in front of VLOOKUP

The only thing left is it is not calculating the GST - I changed the "N" to "Y" right before the D9.

You are a lifesaver. Thank you so much! I legit spent 12 hours building a spreadsheet yesterday and got super stuck on this ONE part.