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 !!!

:-)

=ROUNDUP(Your_Sum,0)

--

Vasant


"guillaumet" wrote in message
...
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 !!!

:-)

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

Hi. Would this idea work?

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

--
Dana DeLouis
Win XP & Office 2003


"guillaumet" wrote in message
...
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 !!!

:-)

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

thanks again

"Vasant Nanavati" wrote:

=ROUNDUP(Your_Sum,0)

--

Vasant


"guillaumet" wrote in message
...
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 !!!

:-)

How about

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

Mike

"guillaumet" wrote:

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

thanks again

"Vasant Nanavati" wrote:

=ROUNDUP(Your_Sum,0)

--

Vasant


"guillaumet" wrote in message
...
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 !!!

:-)

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

"Dana DeLouis" wrote:

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

Hi. Would this idea work?

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

--
Dana DeLouis
Win XP & Office 2003


"guillaumet" wrote in message
...
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 !!!

:-)