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

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

in B1
=if(C1="yes",A1,"")

If I am reading your question correctly?

alternate interpretation
in C1
=if(B1=A1,"yes","")

"danielle" wrote:

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