Formula Errors
 

Hi All,

Is there anyone who can help me? I am stuck on this formula, which
doesn't achieve the right results.

Here is the formula: -

=IF(OR(F16="",COUNTBLANK(F17)*OR(COUNTBLANK(F22)0 ))),"",COUNTA(F16F17,F22,MAX(F17,F22))*OR(F16<F17 ,F22=F16)*OR(F16=F17,F22=F16)

The COUNTBLANK just check if F16 is blank don't display in F15. Which
WORKS!

What i am trying to achieve with COUNTA is : -

1. If F16 is greater than F17 and F22 then display the MAX of F17 and
F22.
2. The second part If F16 less than F17 and F22 then display F16.
3. And finally if F16 is equal to F17 and F22 then display F16.

Many thanks

Imran

Formula Errors
 

=min(F16,Max(F17,F22))

You can incorporate checking for blanks.

--
Regards,
Tom Ogilvy



" wrote:

Hi All,

Is there anyone who can help me? I am stuck on this formula, which
doesn't achieve the right results.

Here is the formula: -

=IF(OR(F16="",COUNTBLANK(F17)*OR(COUNTBLANK(F22)0 ))),"",COUNTA(F16F17,F22,MAX(F17,F22))*OR(F16<F17 ,F22=F16)*OR(F16=F17,F22=F16)

The COUNTBLANK just check if F16 is blank don't display in F15. Which
WORKS!

What i am trying to achieve with COUNTA is : -

1. If F16 is greater than F17 and F22 then display the MAX of F17 and
F22.
2. The second part If F16 less than F17 and F22 then display F16.
3. And finally if F16 is equal to F17 and F22 then display F16.

Many thanks

Imran

Formula Errors
 

Many thank Tom Got it working!
Tom Ogilvy wrote:
=min(F16,Max(F17,F22))

You can incorporate checking for blanks.

--
Regards,
Tom Ogilvy



" wrote:

Hi All,

Is there anyone who can help me? I am stuck on this formula, which
doesn't achieve the right results.

Here is the formula: -

=IF(OR(F16="",COUNTBLANK(F17)*OR(COUNTBLANK(F22)0 ))),"",COUNTA(F16F17,F22,MAX(F17,F22))*OR(F16<F17 ,F22=F16)*OR(F16=F17,F22=F16)

The COUNTBLANK just check if F16 is blank don't display in F15. Which
WORKS!

What i am trying to achieve with COUNTA is : -

1. If F16 is greater than F17 and F22 then display the MAX of F17 and
F22.
2. The second part If F16 less than F17 and F22 then display F16.
3. And finally if F16 is equal to F17 and F22 then display F16.

Many thanks

Imran