Need an Excel Expert
Project description
Small work: Need an Excel expert to update the calculations on a very simple spreadsheet. Need to update THIS SPREADSHEET: https://docs.google.com/spreadsheets/d/1K-0jJSDfviaNgp3FBMOuFgDi_M6KbPpf/edit?usp=sharing&ouid=107553646337182128163&rtpof=true&sd=true Instructions: The only editable fields should be the Green fields I13 & I14 Cells I6-I9 need to auto calculate based on the correlating description fields also defined below. Cell I6: If value in cell I15 is at or greater than $5,000,000 then this cell will autofill at $5,000,000, if the value in cell I15 is less than $5m, then this value will be the same as the value in cell I15 and cells I7-I9 will turn to $0 Cell I7: If value in cell I15 is greater than $5,000,000 then this cell will autofill at that value minus $5m, if the value in cell I15 is at or greater than $10m, then this value will max out at $5m and cells I8-I9 will turn to $0 Cell I8: If value in cell I15 is greater than $10,000,000 then this cell will autofill at that value minus $10m, if the value in cell I15 is at or greater than $30m, then this value will max out at $20m and cell I9 will turn to $0 Cell I9: If value in cell I15 is greater than $30,000,000 then this cell will autofill at that value minus $30m.
Project scope
Required software
- MS Office
Skills
- Data analytics
Location
Cedar Pointe Drive, Mooresville, North Carolina 28117, United States
Share this project!