=IfError & =if function in one cell??

[Muzza86]

I have a hyperlink rollover set up which uses a iferror statement in the cell, but I want to add another separate if statement in the same cell. is this possible?

current formula is: =iferror(hyperlink(rollover($d6,e$9),""),"") and I want to add another separate if statement afterwards.

[alansidman]

It may be possible depending on what the function you are testing. You can nest if statements.

http://www.techonthenet.com/excel/fo.../if_nested.php