Formula to give me zero value instead of blank

[Ecel Dumbo]

Hello,


I have a formula

IF(ISERROR(IF($H$99>0,G90*$H$99,0)),"",IF($H$99>0,G90*$H$99,0))


which sometimes gives me blank answer. I would like the result to show up as $0 instead of blank


THe reason I have other formula which are linked to the result from the above formula

Example - ($10,000 - result of above formula). If the result of above formula is blank, I get the value of the last formula as blank and not $10,000.


I hope you understood my problem

 

[Hui]

Change the "" and 0 at the end to "$0"

 

[Ecel Dumbo]

thanks Hui. Appreciate your help. It worked. I just changed "" to "$0"