if statements in spreadsheets???????????

System
System Posts: 100,534 🤖 Admin 🤖
edited June 18 in AAT student discussion
Hello, can anyone help, I am doing an assigment for IT module and I can't get an if statement to work, is there anyone out there who knows this stuff? <BR><BR>Regards.

Comments

  • System
    System Posts: 100,534 🤖 Admin 🤖
    if statements in spreadsheets???????????

    Hi, silly question I know, but have you tried the help option in excel, it shows some examples etc. I'm just about to log off, but why don't you post another message with the statement that you're trying to use and someone might be able to tell you where you're going wrong.
  • System
    System Posts: 100,534 🤖 Admin 🤖
    if statements in spreadsheets???????????

    You may not have typed the 'IF' statement correctly - an easy mistake to make.<BR><BR>It should read<BR><BR>IF(cell=value,"positive answer","negative answer")<BR><BR>eg if you're testing to see whether cell B2 contains the text yellow and want the answer to show as either "Yes" or "No",<BR><BR>IF(B2="yellow","Yes","No")<BR><BR>or if you want to see whether the figure in cell B2 is a positive figure, and if so have the amount displayed<BR><BR>IF(B2>0,B2,"")<BR><BR>Hope this helps :o)

Categories

Privacy Policy