I am trying to get a spreadsheet to work how I want it to, and despite doing quite a bit of internet searching, I still cant figure this out. Please see attachment.
Amount applied this week is calculated by taking contract amount, multiplied by amount applied, then multiplying again by % completed this period. The way I format this is that under job type "ER" will always be a 60% value for what is shown in %Applied, and "TD" is 40%, and SERV is 100%. I'd like to be able to compute the amount applied this week by only needing the "job type" column and having the sheet know to multiply those percentage values.
I'll try to clarify if this is confusing.
Bookmarks