help!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
in B1
=if(C1="yes",A1,"")

If I am reading your question correctly?

alternate interpretation
in C1
=if(B1=A1,"yes","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF "value if false" not working 2
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
Excel functions 0
Vlookup and Indirect 0
Comparing cell contents with different reference cells 3
Countifs with different restrictions 1
Help with automatically sorting data 1
Merging cells and formats 8

Back
Top