A.I.M. Users Bulletin Board

[Conrad]

=IF(B29<>"",J29*D29/100,"")

Mijn Excel (Office 2000)does not even accept this statement.
It would appear to mean that if B29 is smaller or larger than 1/100 of the product J29 and D29 then the cell would give 0 value, otherwise it give the value J29*D28/100. . .but the ""xxxxx"" is not accepted.

I wonder too what it means.

If I change it to
=IF(B29<>",J29*D29/100,")
then it does not work eiter but is accepted as

#NAME?

for every number in cell B29 (or nothing in it), where the statement is typed in.