Cost calculator

Hi,

I need to make a cost calculator for pricing Virtual Servers.

There are three offerings:

Small, 1 vCPU, 4 GB Mem, 100GB
Medium, 2 vCPU, 12GB Mem, 250GB
Large, 4 vCPU, 32GB Mem, 500GB

If any of the values fall within the next level then it becomes that size. So if it was 1 vCPU, 4 GB Mem, 500GB, then it would be large.

I’d like to have a drop down box where the user could choose a value and then it would say if it’s small medium or large.

I was working with this:

=IF(OR(C8=1, D8=4, E8=100 ), "Small",IF(OR(C8=4, D8=32, E8=500 ), "Large","medium"))

But I’m not sure this will work because of the way it evaluates it. Am I on the right track or is there an easier way to do it? Should I use some sort of lookup table?

Any advice welcome.

Thanks.

Martin.

Mcmahoot,

Thanks for your reply,

That wouldn't work because, as in the example: 1 vCPU, 4 GB Mem, 500GB = Large, any value that is above the baseline would make it a different size.

Thanks.

Martin.