#1   Report Post  
Old May 20th 05, 12:50 AM
BorisS
 
Posts: n/a
Default 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   Report Post  
Old May 20th 05, 04:16 AM
Biff
 
Posts: n/a
Default

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   Report Post  
Old May 20th 05, 04:25 AM
Biff
 
Posts: n/a
Default

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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting based on Text within Text George Lynch Excel Discussion (Misc queries) 3 May 5th 05 07:58 PM
Conditional formatting of text LeAnne New Users to Excel 7 March 4th 05 02:34 PM
Conditional Formatting of Text... Birmangirl Excel Discussion (Misc queries) 3 January 19th 05 02:45 PM
Conditional Formating when result is text Lary Excel Worksheet Functions 1 December 16th 04 02:13 AM
conditional format for text Kim Excel Worksheet Functions 7 November 3rd 04 04:33 PM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017