Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |