IF, Celing and Max within one formula?

[Lesjoan01]

Hi everyone,

does anyone have any examples where IF, Ceiling and MAX are used in one formula?

I have been asked by one of my users about this. I do not have any data to apply this to, I just wanted to check if it is 'do-able'

Many thanks

L

 

[Special-K99]

Yes, here you go.

=CEILING(3,MAX(IF(A1=1,3,6),10))

Of course, this is complete nonsense since I just typed in some random numbers and don't have any application whatsoever to apply this to.
It simply is an example of an IF a CEILING and a MAX used in one formula
Yet it does answer your question.

You need to get the user to explain what they are trying to achieve.
Then apply appropriate formulas and if possible combine them.

 

[KolGuyXcel]

Maybe this could be a practical example!

Assuming a company offers transportation to its employees and it has only 4 seater cabs in its fleet! A combination of IF, Ceiling and Max could be used to find out the maximum of cars required in a particular data range, depending on the roster of the employees within that date range.

 

[Lesjoan01]

Hi,

thank you for that - I appreciate it is difficult without physical data - I just wanted to check it was possible

Thanks again

L

 

[Lesjoan01]

KolGuyXcel - thank you for your example - much appreciated

Kind regards

L