Mark zero variables

[Matti Koski]

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

 

[Bob Phillips]

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

--
HTH

Bob

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

 

[Guest]

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

 

[Matti Koski]

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

Matti

 

[Dave Peterson]

Maybe...

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

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

Matti