Help with formula

[Guest]

Hi,

I have the following formulat that helps calculate the number of processors
needed from the client/server software appication I sell. Bottom line, if a
customer wants x amount of concurent clients, he will need x/10 processors.
For example, if a customer wants 40 concurent client acess, he will need a 4
processor server.
I also included the fact that 2 processor minimium are required. So if a
customer wants 10x concurent client, he will need a 2 processor server.
The formula below works, I126 referers to a cell that has a total anmount of
concurent clients.

=IF((SUM(I126)/10)<2,2,SUM(I126)/10)

Now, I need to add another formula, that if the SUM has one decimal, than
the SUM should go to the next number. For example if the sum is 2.1, than the
sum should be 3.

Thanks for ANY help !!!

 

[Vasant Nanavati]

=ROUNDUP(Your_Sum,0)

 

[Dana DeLouis]

...I126 referrers to a cell that has a total ...

Hi. Would this idea work?

=MAX(ROUNDUP(I126/10,0),2)

 

[Guest]

Thank you...How should I include the roundup formula inside my formula ?

thanks again

 

[Guest]

How about

=ROUNDUP(IF((SUM(C2)/10)<2,2,SUM(C2)/10),0)

Mike

 

[Guest]

This formula works great ! Thanks again all for sharing your knowledge !