Excel 2007 : IF condition for a blank cell

[kenwatch]

Hello again,

I have this time another question. I want to make a file that shows calculations only when I have data. When data cells are empty, cells with formula should not show anything.
I attached a file as an example of what I am trying to do.
Column A is the data column. Column B will show "o" or "x" depending on the value from column A. I used the following formula: =IF((AND($A1>2.9,$A1<4.9)), "o", "x")
My problem is that I do not know how to write the condition to have nothing showing in column B, when column A is empty. You can see that I have "x" showing from B4 to B10.
There is any way to make that showing nothing, if there is no data in A column?
Thank you,

[Maicon]

Hello again,

I have this time another question. I want to make a file that shows calculations only when I have data. When data cells are empty, cells with formula should not show anything.
I attached a file as an example of what I am trying to do.
Column A is the data column. Column B will show "o" or "x" depending on the value from column A. I used the following formula: =IF((AND($A1>2.9,$A1<4.9)), "o", "x")
My problem is that I do not know how to write the condition to have nothing showing in column B, when column A is empty. You can see that I have "x" showing from B4 to B10.
There is any way to make that showing nothing, if there is no data in A column?
Thank you,

The formula to keep blank spaces would be like this:

=IF($A1="","","x")

I'm not sure if you can manipulate that as a third variant for your formula.

[teylyn]

=IF(ISBLANK(A1),"",IF((AND($A1>2.9,$A1<4.9)), "o", "x"))

copy down

[kenwatch]

Thank you so much Teylyn.
It worked like a charm. It seems that I have a lot of things to learn and this page is really helping me to do so.
Thanks once again.

Ken