Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
showing only positive numbers
=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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
showing only positive numbers
I would create a matrix which replicates the dimensions of the array but
returns blanks for values less than 0. Assume the array is in range A1:B2, to keep things simple. In D1 enter =IF(A10,A1,"") Fill this formula one cell to the right and fill down to the next row. This way, all positive values from the original array are returned and all negative values are ignored (i.e., an empty string/null string is put in their place). Then run your calculation on this new array. Dave -- Brevity is the soul of wit. "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
How do I count how many positive and negative numbers in a couumn | Excel Discussion (Misc queries) | |||
convert numbers to positive and keep delta value | Excel Discussion (Misc queries) | |||
How do I display positive numbers on either side of the x-axis? | Charts and Charting in Excel | |||
average positive numbers | Excel Discussion (Misc queries) |