Using OR in an Excel IF statement
Closed
masvon
-
Sep 26, 2009 at 08:03 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 26, 2009 at 08:48 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 26, 2009 at 08:48 PM
Related:
- Using OR in an Excel IF statement
- Fenix internet on bank statement - Guide
- Excel if statement - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 26, 2009 at 08:48 PM
Sep 26, 2009 at 08:48 PM
quote
IF(OR(B32<=9,B17=10,)"Extended","complete","Extended")
unquote
see the logic
conditon is
either B32>=9 or B17=10
if this conditions is true result should be
"extended"
if this condition is false the result should be
"complete"
why is that another "extended
there is no third alternative.
remove that",extended" inlcuding the comma) in the last and see whether you get what you want
IF(OR(B32<=9,B17=10,)"Extended","complete","Extended")
unquote
see the logic
conditon is
either B32>=9 or B17=10
if this conditions is true result should be
"extended"
if this condition is false the result should be
"complete"
why is that another "extended
there is no third alternative.
remove that",extended" inlcuding the comma) in the last and see whether you get what you want
