Reputation: 95
I am building an excel sheet for our sales team that calculates pricing for a hosted system based on the users. It also contains the Part #s for our quoting software so it makes the whole process much easier.
What I have currently have setup forces the user to enter data into the quantity field. I have a spreadsheet that has specs for the servers based on user count. I am just a n00b with excel so I am not sure how to set it up so that I can enter a number in a single field and then based on that number the hardware for the server, RMM monitoring, and exchange mailboxes, etc populates.
Any help is appreciated.
Upvotes: 1
Views: 58
Reputation: 95
I figured it out by using sumif and nested if statements. Thanks for the help all.
Upvotes: 1