On Sun, 5 Mar 2006 15:32:03 -0600, CmTaz
wrote:

Furthermore it also appears that even in a simple IF function excel
does not recognise ¤0.00 as 0. eg if I put in =IF(A!=0,"yes","no") and
A1 contains ¤0.00 it gives the value of no. If I put it as
=IF(A!=¤0.00,"yes","no") it is invalid and finally for
=IF(A!="¤0.00","yes","no") it again shows no.

I assume where you've typed A! above you really mean A1.

What, exactly, is in A1?

In other words, what shows in the formula bar when you select A1?

If A1 truly contains a value of zero, then your first formula will return
"yes".

The usual problem with the sort of result you're describing is that what you
think is zero really is not. Usually that's because the value is derived from
a formula, and the inherent problems with decimal-binary conversions and 15
decimal digit precision (inherent in most every computer spreadsheet program)
result in a number that's off a little bit from zero.

Some errors are due to mixing text and numeric values, which may look the same,
but are not. You must ensure that the values you are comparing are both
numeric (or both text). Else you will get unexpected results.

There are a number of solutions. One way is to check the rounded (to two
decimal) value to see if it's equal to zero.

e.g. =IF(ROUND(A1,2)=0,"Yes","No")


--ron