Can anyone help me with the IF function

[Bobsled]

Hello

I'm trying to help my wife with simplifying her scheduling of
employees. She uses 11 different time periods (1-11) some
are worth the same amount of hours others are more or less. I can use
seven functions to describe the period and the
value of hours it is worth, but when I consolidate the functions it
says the formula is invalid. I'm sure it can be
fixed by one of you excel gurus! Here are the functions

IF(B13<4,"7.75")
IF(B13=4,"7.25")
IF(B13=5,"6.25")
IF(B13=6,"7.75")
IF(B13=7,"6.75")
IF(B13=8,"6.25")
IF(B13>8,"4")

Each individually works great! When I consolidate it to the following
formula excel tells me the following formula
contains an error, and when I click on the summation sign the first
part of the function is considered invalid. Please
help me as I'am at a dead end! Thanks

IF((B13<4,"7.75"),IF(B13=4,"7.25"),IF(B13=5,"6.25"),IF(B13=6,"7.75"),IF(B13=7,"6.75"),IF(B13=8,"6.25"),IF(B13>8,"4"))

BTW what I want this formula to do is when I type 1-11 the appropriate
hour value associated with that period is displayed. This way she can
quickly describe the period time frame and can easily track hours.

 

[JE McGimpsey]

One way:

=CHOOSE(MIN(MAX(1,B13-2),7),7.75,7.25,6.25,7.75,6.75,6.25,4)

 

[mrice]

Slight rearrangement of the commas and brackets...

=IF(B13<4,"7.75",IF(B13=4,"7.25",IF(B13=5,"6.25",IF(B13=6,"7.75",IF(B13=7,"6.75",IF(B13=8,"6.25
",IF(B13>8,"4")))))))

 

[Dana DeLouis]

One interesting option if you have a helper column that limits the values to
the integers 3,4,5,6,7,8, or 9, then maybe:

=MOD(1262136775,A1+30)/4