More conditions needed

[Nascarnut]

Please Help
I am creating an invoice and I need some help with a certain formula

tax1.xls
	A	B	C	D	E	F	G	H
1		TAXABLE				5.0%	TAX	TOTAL
2		$2,343.45			$37.50	$119.05	$156.55	$2,500.00
3					city	state	total
Sheet1

I need E2 to also say that if F1 is anything other than 5% then E2 =""

Thanks in advance[/url]

 

[Aladin Akyurek]

=IF(F1=0.05,IF(H2>=2500,37.5,H2-(H2/1.015)),"")

 

[Tazguy37]

Like this?:

=IF(H2>=2500,37.5,IF(F1<>0.05,"",H2-(H2/1.015)))

Not exactly sure what you're after here.

 

[Oaktree]

E2 =IF(F1=.05,IF(H2>=2500,37.5,H2-(H2/1.015)),"")

 

[Nascarnut]

A Million ThankYou's!!!
ray: ray: ray:
I'm not worthy of you great wisdom