Remember Me?

#1
May 20th 05, 12:50 AM
 BorisS Posts: n/a
conditional text

I have two cells, one of which is always filled in first, and then another.
For the formatting (changing from no fill/blk text) I am using the obvious
conditional formula. However, when the first is filled, I'd like the second
to also pop text up that says "second line?". I've tried the following:
=not(isblank(cell previous))*"second line?"
and this gives me a value? error.

Is the use of the "trueness" of the first argument not possible to multiply,
like you can with numerical calculation? Do I have to go for the if
statement in this case, or is there some way of using this? The reason it's
important is because if I can use the above format, it allows for cleaner
cells when more than just this one condition is involved.

Thanks if you have some insight.
--
Boris

#2
May 20th 05, 04:16 AM
 Biff Posts: n/a

Hi!

It's not very clear what you want so here's my best guess:

=IF(A1<"","second line?")

=not(isblank(cell previous))*"second line?"

Is the use of the "trueness" of the first argument not possible to
multiply,
like you can with numerical calculation?

The problem is that you're trying to multiply different types of data. A
boolean * TEXT = #VALUE!

Maybe something like this:

=(A1<"")*(B1="second line?")

Biff

"BorisS" wrote in message
...
I have two cells, one of which is always filled in first, and then another.
For the formatting (changing from no fill/blk text) I am using the obvious
conditional formula. However, when the first is filled, I'd like the
second
to also pop text up that says "second line?". I've tried the following:
=not(isblank(cell previous))*"second line?"
and this gives me a value? error.

Is the use of the "trueness" of the first argument not possible to
multiply,
like you can with numerical calculation? Do I have to go for the if
statement in this case, or is there some way of using this? The reason
it's
important is because if I can use the above format, it allows for cleaner
cells when more than just this one condition is involved.

Thanks if you have some insight.
--
Boris

#3
May 20th 05, 04:25 AM
 Biff Posts: n/a

Ooops!

=IF(A1<"","second line?")

Should be:

=IF(A1<"","second line?","")

Biff

"Biff" wrote in message
...
Hi!

It's not very clear what you want so here's my best guess:

=IF(A1<"","second line?")

=not(isblank(cell previous))*"second line?"

Is the use of the "trueness" of the first argument not possible to
multiply,
like you can with numerical calculation?

The problem is that you're trying to multiply different types of data. A
boolean * TEXT = #VALUE!

Maybe something like this:

=(A1<"")*(B1="second line?")

Biff

"BorisS" wrote in message
...
I have two cells, one of which is always filled in first, and then
another.
For the formatting (changing from no fill/blk text) I am using the
obvious
conditional formula. However, when the first is filled, I'd like the
second
to also pop text up that says "second line?". I've tried the following:
=not(isblank(cell previous))*"second line?"
and this gives me a value? error.

Is the use of the "trueness" of the first argument not possible to
multiply,
like you can with numerical calculation? Do I have to go for the if
statement in this case, or is there some way of using this? The reason
it's
important is because if I can use the above format, it allows for cleaner
cells when more than just this one condition is involved.

Thanks if you have some insight.
--
Boris

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post George Lynch Excel Discussion (Misc queries) 3 May 5th 05 07:58 PM LeAnne New Users to Excel 7 March 4th 05 02:34 PM Birmangirl Excel Discussion (Misc queries) 3 January 19th 05 02:45 PM Lary Excel Worksheet Functions 1 December 16th 04 02:13 AM Kim Excel Worksheet Functions 7 November 3rd 04 04:33 PM

All times are GMT +1. The time now is 09:50 AM.