Dum IF statement question!

[jackmccarthy]

Hello
I have a calculated column in powerpivot that has numbers 0 thur 24 called "hour of day" That represent the hours of the day.
I need to say if the hour is 0 to 8 "GRAVE" 8 TO 16 "DAY" AND 16 TO 24 "SWING". Can someone please give me the =if statement for this?

This is what I have. Not working
=IF([hour of day]<8,"GRAVE",IF([hour of day]<16,"DAY","SWING"))THANKS </pre>

 

[MD610]

What about...
=SWITCH(TRUE(), [hour of day]<=8, "GRAVE", [hour of day]>8 && [hour of day]<=16, "DAY", "SWING")

Or just replace the argument for your second IF statment with this one: [hour of day]>8 && [hour of day]<=16

You might have to play with the <=, <, >, and >= depending on where you need to group the 8 and 16.

 

[jackmccarthy]

Gives me error to many if arguments were passed

 

[MD610]

You are missing or have misplaced a comma or parenthesis somewhere.

 

[MD610]

=IF([hour of day]<8,"GRAVE",IF([hour of day]>8 && [hour of day]<=16,"DAY","SWING"))

This or the SWITCH() should give the same result...aside from the variations in the <, <= etc. that you need to adjust depending on where you want the 8 and 16.

 

[jackmccarthy]

This is what I have =IF([hour of day]<8,"GRAVE",IF([hour of day]>8 && [hour of day]<=16 ))

 

[MD610]

It needs to be this:
=IF([hour of day]<=8,"GRAVE",IF([hour of day]>8 && [hour of day]<=16,"DAY","SWING"))

This will make the 8's part of GRAVE and the 16's part of DAY.

 

[jackmccarthy]

=IF([hour of day]<8,"GRAVE",IF([hour of day]>8 && [hour of day]<=16,"DAY","SWING") ok now I am returning swing in all rows of column

 

[MD610]

Is your table filtered to just show SWING somewhere?

 

[jackmccarthy]

no????????? ready to throw this thing accross the room...lol