Need an Excel Expert

Published: Jan 27 2023
Valid until: Feb 26 2023
Hourly rate:$20-$50/h

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.


See more details... (1)

Project scope

Project done

Required software

  • MS Office

Skills

  • Data analytics

Location

Cedar Pointe Drive, Mooresville, North Carolina 28117, United States

Share this project!

Benefits of joining SoftwareSupport
  • Guaranteed payment
  • 24 hours to get work
  • 20 new jobs every week

Create your expert profile to apply for projects