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

[bill]

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.

[LER]

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.

[Melanie]

You may not have typed the 'IF' statement correctly - an easy mistake to make.<BR><BR>It should read<BR><BR>IF(cell=value,&quot;positive answer&quot;,&quot;negative answer&quot;)<BR><BR>eg if you're testing to see whether cell B2 contains the text yellow and want the answer to show as either &quot;Yes&quot; or &quot;No&quot;,<BR><BR>IF(B2=&quot;yellow&quot;,&quot;Yes&quot;,&quot;No&quot;)<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&gt;0,B2,&quot;&quot;)<BR><BR>Hope this helps :o)