Help me with excel please

[Jakalwarrior]

I made a grade sheet for my mother (teacher) and I got all of the formulas figured out fine except for one. I want the average to not be able to go over 100 (throws overall grade off if individual subject goes over 100). I thought I could do something like:

=IF(AVERAGE(E3:IV3)=<100%,(AVERAGE(E3:IV3),100))

But I just cant get it to work!

[lisakki]

=IF(AVERAGE(E3:IV3)<=100,AVERAGE(E3:IV3),100)

Try copy pasting that.

I think you just messed up the parentheses.

[Jakalwarrior]

I did eventually get it by using the built in formula constructor (You were right, a matter of parentheses). Of course then she tells me they gave her some software to do it for her! booo.

[acyckowski]

another way to do it is

=min(average(e3:iv3),100)

but lisakki is right, you messed up the parentheses.