Excel formulas and auto fill

Question

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.

Answer 1

I figured it out by using sumif and nested if statements. Thanks for the help all.