Solve : Microsoft Excel Formula Query?

1.	Solve : Microsoft Excel Formula Query?
Answer» Hi, I am trying to find out how I can use the IF function to display results in a specific CELL, for EXAMPLE; if cell a1>20 then I WANT the True to appear in cell k2, if the answer is false then appear in k3. I am having no trouble using the standard IF function but I have no idea how to go about building on it (SORRY). I am currently using Excel 2003. Any help would be appreciated. ThanksDo you mean k3 would show "False"? If so, here are formulas for k2 and k3: In k2, put =IF(A1>20,"True","") In k3, put =IF(A1>20,"","False") Thank you so much, that is my problem sorted. Much appreciated.

Discussion