Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Errors / #Value! | Excel Worksheet Functions | |||
Mod a Formula For Errors | Excel Worksheet Functions | |||
Formula errors | Excel Worksheet Functions | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |