Nested IF Statement Help Pls

Hi,
I was hoping someone can help me write a formula for the below:
If cell A1 is blank, then “No Data” else A1*B1. But if A1*B1 is error, then “Infinite”


Thanks
Gautam

Hi,

Try,

=IF(A1="","No Data",IF(ISERROR(A1*B1),"Infinite",A1*B1))

HTH
Steve

Thanks Steve, it works !