Fridflenstone
Fridflenstone

Reputation: 95

Excel formulas and auto fill

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

Answers (1)

Fridflenstone
Fridflenstone

Reputation: 95

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

Upvotes: 1

Related Questions