Using OR in an Excel IF statement
Closed
masvon
-
26 Sep 2009 à 20:03
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 26 Sep 2009 à 20:48
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 26 Sep 2009 à 20:48
Related:
- Using OR in an Excel IF statement
- Excel mod apk for pc - Download - Spreadsheets
- More than 1 if statement excel - Guide
- Arrow keys not working in excel - Guide
- Vat calculation excel - Guide
- How to clear formatting in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
26 Sep 2009 à 20:48
26 Sep 2009 à 20:48
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
