Put Option Real Estate

Document Sample
Put Option Real Estate Powered By Docstoc
					Basic SUMIF                      You use the basic SUMIF when you want to sum up a set of values that me

                      Values     Option 1
                           100   Criteria      >20
                           101   Sum              1,605.00
                           102
                           103   Option 2
                           104   Sum                1,605.00
                           105
                           106
                           107
                           108
                           109
                           110
                           111
                           112
                           113
                           114

Advanced SUMIF                   SUMIF can also be used to sum up values based on a corresponding set o

         Month        Values     How do we sum all of the values that correspond to the months that are gre
                  1        100
                  2        101   Option 1
                  3        102   Criteria      >6
                  4        103   Sum                     990
                  5        104
                  6        105   Option 2
                  7        106   Sum                     990
                  8        107
                  9        108
                 10        109
                 11        110
                 12        111
                 13        112
                 14        113
                 15        114

SUMPRODUCT                       What do we do if we want to run simultaneous SUMIFs? While there is a S

                                               Lower Limit       Upper Limit       Sumproduct
                                 Criteria                    4          10             530
         Month        Values
                 1         100                               0           1
                 2         101                               0           1
                 3         102                               0           1
                 4         103                               0           1
                 5         104                               1           1
                 6         105                               1           1
                  7       106                               1           1
                  8       107                               1           1
                  9       108                               1           1
                 10       109                               1           0
                 11       110                               1           0
                 12       111                               1           0
                 13       112                               1           0
                 14       113                               1           0
                 15       114                               1           0


Array Formula
                                 Can we acheieve multiple SUMIFs without using SUMPRODUCT? Yes, we
         Month        Values
                  1        100   Sum                      530
                  2        101
                  3        102   After you write out the formula, simply click into the cell and press control-s
                  4        103    Excel will then turn the formula into an array formula and apply it to the en
                  5        104
                  6        105   Array formulas are extremely powerful as they can condense complex calc
                  7        106
                  8        107
                  9        108
                 10        109
                 11        110
                 12        111
                 13        112
                 14        113
                 15        114
p a set of values that meet a certain criteria.




on a corresponding set of values such as months that correspond with cash flows.

o the months that are greater than 6?




MIFs? While there is a SUMIFS function in Excel 2007, it's not backward compatible with Excel 2003. We can use SUMPRODUCT instead to

 Sumproduct
          <-- This is the sum of the values to correspond to months that are greater than 4 and less than 10.
UMPRODUCT? Yes, we can do so through the use of an array formula.



e cell and press control-shift-enter to put braces around the formula.
ula and apply it to the entire array.

 condense complex calculations into single cells.
SUMPRODUCT instead to generate the same result.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:8/1/2011
language:English
pages:5
Description: Put Option Real Estate document sample