View Single Post
  #8   Report Post  
Bob Phillips
 
Posts: n/a
Default

What &, what ;?

Do you have a continental version of Excel? If so, it would be something
like

=IF(A10;"Yes";"No")

& only comes in with COUNTIF/SUMIF and comparison to a cell

=SUMIF($A:$A;""&C1,$B:$B)

--
HTH

Bob Phillips

"ellebelle" wrote in message
...
I have tried this and many combinations - it is not working.

do I include the & symbol and the ; symbol?

e

"Max" wrote:

.. greater than zero

Key in: 0

.. does not equal zero

Key in: <0
("<" means: does not equal)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ellebelle" wrote in message
...
thanks - silly question but how do you inset greater than zero in a

function
OR does not equal zero?