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?
|