=IF(A1B1,A1-B1,"")
--
Gary's Student


"didcrywolf" wrote:

I need to calculate the value of an array but only SHOWING positive numbers
to be added. How would I formulate it?

example : i have a warrant on a stock priced at 4.50 if the stock is trading
at 5.00 the warrant has an intrinsic value of 5.00-4.50= 50 cents but if the
stock trades at 4.00 the warrant does not have a negative value of 50 cents...

Thank you for your help