IF, Then, But, Aarrggg!

[Maugrim]

I'm having some problems with an IF Function. This is what I've got:

=IF(G4<0.8,G4+S4,G4)

And it works fine. My problem is, see the G4+S4, I want to put an
upper limit of 0.8 on the sum of those two cells.

Background:
G4 is the mark the student received on the midterm. S4 is the number
of bonus marks to be added to the midterm score, but only to those
midterms scored under 0.8 (80%). The formula I have works this far.

Now, I don't want those students who receive bonus marks to get more
than 0.8 once the bonus marks have been added.

Can anyone point me in the right direction?

Thanks in advance.

 

[Bondi]

Hi Maugrim,

Maybe you can use something like this:

=IF(G4<0.8,IF(G4+S4>=0.8,0.8,G4+S4),G4)

Regrads,
Bondi

 

[Guest]

Hi, Maugrim,

try to use:

=IF(G4<0.8,IF((G4+S4)>0.8,0.8,G4))

does this help?
regards from Brazil
Marcelo

"Maugrim" escreveu:

 

[Guest]

try
=min(0.8,G4+S4)