1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice

Excel 2007 help

Discussion in 'Computing and ICT' started by somebodyelse, Jan 25, 2011.

  1. Could someone please advise? I have 3 columns in a spreadsheet with text in the cells. If all 3 cells in a row in these columns each say "Pass" then I want the fourth column to say something else - Total Pass or whatever. I think it must be an If or an And -but I am really stuck as to how to phrase it! Thanks
     
  2. For an IF and an AND, if its for Level 3 Key Skills, try:

    =IF(AND(A1="PASS",B1="PASS",C1="PASS"),"TOTAL PASS","FAIL")
     
  3. thanks to everyone - I will go and have a try :D]
     

Share This Page