View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
didcrywolf didcrywolf is offline
external usenet poster
 
Posts: 1
Default showing only positive numbers

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