IF formula based on 4 criterias

[oneleg]

Hello,

I have an Excel document where cell F35 sums up the total from cells F25:F34.

Based on the result, I'm trying to, in cell F36, have a different value based on the following criterias:

• If the value of F35 is 0, I wish to have 0 in cell F36
• If the value of F35 is 1, I wish to have 45 in cell F36
• If the value of F35 is either 2, 3 or 4, I wish to have 60 in cell F36
• If the value of F35 is 5 or greater, I wish to have 80 in cell F36

What is the formula to make this happen ?

Thanks in advance...

 

[Weazel]

maybe something like...

=IF(F35=0,0,IF(F35=1,45,IF(F35<5,60,80)))