Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Rent PSF Formula?
Hi - I have an excel spreadsheet for an office building that I need to
calculate the average rent per square foot. In the spreadsheet I have 5 columns: 1 - Leased area (sf), 2 - term of the lease (mo), 3 - rental rate for yr 1 ($), 4 - annual increase (%), and 5 - the months of free rent. I need the formula to take this information and spit out the average rent per square foot. Thanks for the help! Here is what it looks like in excel: Leased SF Term Rent Yr 1 Annual Increase Mo. Free Rent Avg. Rent PSF 2,755 65 $20 3% 5 ??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average rent per square foot formula | Excel Discussion (Misc queries) | |||
A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
formula to calculate total rent charges | Excel Discussion (Misc queries) | |||
weighted average rent with growth | Excel Worksheet Functions | |||
how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions |