ExcelBanter - IF = Show "NIL" ...?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF = Show "NIL" ...? (https://www.excelbanter.com/excel-discussion-misc-queries/64961-if-%3D-show-nil.html)

JonatanRaven

IF = Show "NIL" ...?

A new problem has arisen.

I want to create a formula that will check if a certain cell has any
text and if so show that text in another cell. If there is no text, I
want excel to show nothing. I think standard is 0.

Any ideas..?

/Jonatan

--
JonatanRaven

------------------------------------------------------------------------
JonatanRaven's Profile: http://www.excelforum.com/member.php...o&userid=30425
View this thread: http://www.excelforum.com/showthread...hreadid=500992

JE McGimpsey

IF = Show "NIL" ...?

One way:

=IF(A1<"", A1, "")

In article ,
JonatanRaven
wrote:

A new problem has arisen.

I want to create a formula that will check if a certain cell has any
text and if so show that text in another cell. If there is no text, I
want excel to show nothing. I think standard is 0.

Any ideas..?

/Jonatan

JonatanRaven

IF = Show "NIL" ...?

JE McGimpsey Wrote:
One way:

=IF(A1<"", A1, "")

Thanks a lot.. :cool:

--
JonatanRaven

------------------------------------------------------------------------
JonatanRaven's Profile: http://www.excelforum.com/member.php...o&userid=30425
View this thread: http://www.excelforum.com/showthread...hreadid=500992

All times are GMT +1. The time now is 03:00 AM.