Microsoft Excel Formula Query

[Lorraine]

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.

Thanks

[soybean]

Do 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")

[Lorraine]

Thank you so much, that is my problem sorted.

Much appreciated.