Mark zero variables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matti Koski - 06 Mar 2007 09:00 GMT

I would like to mark all varables (column 1) that have zero values in column
2 to column 3 as *. How?

a 5
a 3
a 4
b 9 *
b *
c 4
c 7
c 2
g *
g 1 *
g *
g 2 *

Matti

Reply to this Message

Bob Phillips - 06 Mar 2007 09:04 GMT

Do you want to explain how you get those * results?

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I would like to mark all varables (column 1) that have zero values in
>column 2 to column 3 as *. How?
[quoted text clipped - 13 lines]
>
> Matti

Reply to this Message

Gary''s Student - 06 Mar 2007 11:12 GMT

if C1 enter:
=IF(B1="","*","") and copy down

Signature

Gary''s Student
gsnu200709

> I would like to mark all varables (column 1) that have zero values in column
> 2 to column 3 as *. How?
[quoted text clipped - 13 lines]
>
> Matti

Reply to this Message

Matti Koski - 06 Mar 2007 14:03 GMT

All b and g variables should be marked, not only the empty rows.

Matti

> if C1 enter:
> =IF(B1="","*","") and copy down
[quoted text clipped - 17 lines]
>>
>> Matti

Reply to this Message

Dave Peterson - 06 Mar 2007 14:47 GMT

Maybe...

=if(or(a1="b",a1="g",b1=""),"*","")

> All b and g variables should be marked, not only the empty rows.
>
[quoted text clipped - 24 lines]
> >>
> >> Matti

Signature

Dave Peterson

Reply to this Message