Weird If/Then help needed

I am making a weighted grade-book but am having an issue finding the right formula. Basically I have weights laid out for each each student, but if a student doesn't get a grade in any of the applicable fields, then I want the weight to be 0 instead of 10%.

Is there a way I can automate that if there are values in ANY of these cells A4, G4, M4, then the value of cell Y4 = 10%. If no values in A4, G4, M4 then Y4 = 0.

Anyone know what I can do here? Thanks in advance for the help.

Try

=IF(COUNT(A4,G4,M4),0.1,0)

Y formatted as %

Originally Posted by JohnTopley

Try

=IF(COUNT(A4,G4,M4),0.1,0)

Y formatted as %

This worked perfectly! Thank you very much!

Also try.
=IF(AND(A4>1,G4>1,M4>1),10)
& y formatted as percentage %

Originally Posted by JohnTopley

@AVK: should be OR

=IF(OR(A4>0,G4>0,M4>0),0.1,0)

y formatted as percentage %

yes john.
=IF(OR(A4>0,G4>0,M4>0),10,0)

Very welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.