| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset function gives different answer in columns v Rows
I have a set of numbers by year and am trying to get the NPV on forward
basis. I used the Offset function to allow for NPV on different dates. However, the same set of numbers gives a different result if entered in columns v rows. The difference is always out by .06001. Could someone explain why or what I am doing wrong? Data in a ROW =NPV(U$64,OFFSET($D65,0,Lookforward,1,COLUMNS($D65 :$R65)-Lookforward))*(1+U$64)^0.5 Data in a Column =NPV($U58,OFFSET($Q$11,Lookforward,0,ROWS($Q$11:$Q $40)-Lookforward),1)*(1+$U58)^0.5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset code for dynamic row# & multiple columns in LINEST function | Excel Worksheet Functions | |||
| OFFSET function in named range returning wrong # of rows | Excel Worksheet Functions | |||
| hiding columns or rows not using the hide function | Excel Worksheet Functions | |||
| creating columns with data from offset rows | Excel Discussion (Misc queries) | |||
| how do i reference multiple rows/columns with one function? | New Users to Excel | |||
Threaded Mode
