In B1 put this formula..........

=IF(C1="yes",A1,"")

Vaya con Dios,
Chuck, CABGx3




"danielle" wrote in message
...
If A1(max score)=5, B1(actual score) is empty, and C1(not applicable) is
empty:
What function do I use if: C1 is yes, then value in B1 is the
same as value in A1