Using OR in an Excel IF statement

Closed
masvon - Sep 26, 2009 at 08:03 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 26, 2009 at 08:48 PM
Hello,
I am using the flowing to calculate:

IF(OR(B32<=9,B17=10,)"Extended","complete","Extended")

IF B32 is less then or equal too 9 than cell B33 is extended if its not than its complete OR if B17 = 10 then B32 is Extended

I keep getting an error....HELP

MS

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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
0