Need help with nested if search formula

[mmctighe]

Looking for some help with a formula that figures use tax based on type of job and state.
Excel version 2016, windows 10

D4 can be install or product
I currently have a working formula =IF(ISERROR(SEARCH("inst",$D4)),0,((L4+Q4)*0.06))
If D4 contains inst it will multiply cost of job by .06 to figure out my use tax, if D4 is anything else (example: product) it will return a zero.
L4+Q4=cost of job

I now need the following:
D4 can equal install, product, or phantom
F4 can equal va, md or dc

Logic need to be:
If D4 = Install then multiply (L4+Q4)*.06 current formula works for this
If D4 = Product then it needs to equal 0 current formula works for this
If D4 = Phantom then look at F4, if F4 = VA then solution is zero.
If D4 = Phantom then look at F4, if F4 = MD then I need D4 to equal (L4+Q4)*.06
If D4 = Phantom then look at F4, if F4 = DC then I need DV to equal (L4+Q4)*.0575

Thanks for taking the time to help.

 

[jtakw]

Hi,

Maybe something like this:

Book1
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
4	phantom		dc		0.8625				10					5
Sheet20

Cell Formulas
Range	Formula
H4	=IF(OR(D4="Install",AND(D4="Phantom",F4="MD")),(L4+Q4)*0.06,IF(D4="Phantom",IF(F4="DC",(L4+Q4)*0.0575,0),0))

 

[mmctighe]

thank you! Worked like a champ, thanks for saving me from a headache!

 

[jtakw]

You're welcome, welcome to your first post, glad to have saved you money on aspirin.