Need help with IF statement

[oli123]

Hello, im looking to add an exception to my formula. Cell AN8 refer to various conditions but would also need to look up value in cell X8. If X8 is empty it would need to return $0. Some help would be much appreciated.

Excel Workbook
	AN
8	380.63
Sheet

Thanks a bunch !

 

[Robert Mika]

Hi oli,
maybe like this:

=IF(X8="",TEXT(X8,"$0"),IF(AND($D8="united states",AN$7="Challenger"),$AG8*0.8,IF(AND($D8="united states",AN$7="SGT"),$AG8*0.95,IF(AND($D8="Canada",$I8>=20),$AJ8,IF(AND($D8="Canada",$I8<=20),$AI8,IF(AND($D8="United States",$I8>=20),$AG8,IF(AND($D8="United States",$I8<=20),$AH8,"0")))))))

but do you want the reference to be working together with existing AND's statments?

 

[oli123]

Hi oli,
maybe like this:

=IF(X8="",TEXT(X8,"$0"),IF(AND($D8="united states",AN$7="Challenger"),$AG8*0.8,IF(AND($D8="united states",AN$7="SGT"),$AG8*0.95,IF(AND($D8="Canada",$I8>=20),$AJ8,IF(AND($D8="Canada",$I8<=20),$AI8,IF(AND($D8="United States",$I8>=20),$AG8,IF(AND($D8="United States",$I8<=20),$AH8,"0")))))))

but do you want the reference to be working together with existing AND's statments?

Thank you Robert, yes it would be helpful if the following ref would also work with existing AND statements.

Cheers,
Oli