Setting text to a value

  • Thread starter Thread starter johnnygjr
  • Start date Start date
J

johnnygjr

Hi,

I'm making a spreadsheet for a classroom scenario in which a student
receives 10 points if they get a "Pass" grade for class participation
and 0 points if they get a "Fail" grade.

I'm trying to set the value so that it will be included in the
numerical sum of points for each student. I tried using
this..."=IF(F3="Pass",10,0)" but it says something about going in
circles.

I'd greatly appreciate the help. Thanks.

Johnny Galbraith
 
You can't have the formula in the same cell where you put the pass/fail
value
put this formula in another cell but F3

=IF(F3="","",LOOKUP(F3,{"Fail";"Pass"},{0;10}))
 
Back
Top