Formula Errors

[ims121uk]

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(F16>F17,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

 

[Guest]

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

You can incorporate checking for blanks.

 

[ims121uk]

Many thank Tom Got it working!

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

You can incorporate checking for blanks.