I have 3 variables that I am working with.
Count (variable to be entered into a cell by the user)
Cost (fixed @$30,000)
Fee (fixed @ $3,000)
Example
Count / Cost / Running Total
1/$30,000/$30,000
2/$33,000/$63,000
3/$36,000/$99,000
4/$39,000/$138,000
Each subsequent unit cost will rise by $3,000 (Fee)
The running total takes into account what has been spent so far.
I cannot simply say (Cost * 4) + ( Fee * 4 ) because that equals ($120,000) + ($12,000) = $132,000 which does not equal the $138,000 that it actually is.
I am hoping someone can help because right know I have this manually entered in a separate tab with over 30,000 rows of data, and using VLOOKUP to return column values based on row number that equals the varible entered by the user and the file is over 30 MB.
Thanks in advance
Bookmarks