Does value mean number or just any old entry?

If number:
=count(w4,af4)0
to see if either or both have a number

=count(w4,af4)=1
exactly one have a number

=count(w4,af4)=2
both have numbers

Use
=counta()
to count any entry--numbers, text, even formulas that evaluate to "".



Ann Scharpf wrote:

I am trying to apply a conditional format to a cell when either/both of two
other cells on the row contain a value. I have tried every permutation I can
think of but nothing is working. I'm pasting a couple of variants of what
I've tried. (I also tried zero in the place of the one.)

Can anyone advise what I am doing wrong? Thanks!

=((W4+AF4)1)
=((W4+AF4)"1")

=IF((W4+AF4)1,TRUE,FALSE)
=IF((W4+AF4)"1",TRUE,FALSE)

--
Ann Scharpf

--

Dave Peterson