A.I.M. Users Bulletin Board

[Conrad]

Old #7
IF(B29>0,J29*D29/100,0)

I understand you but as you say this would not convey the meaning because if B29 is a negative number or 0 the result would also be zero and mathematically that would not be incorrect, so it would have to be something like this

IF(B29=EMP,EMP,J29*D29/100)

with EMP having the meaning for Empty Cell.

So the question is: how do I find that in Excel form Office 2000?

This type of searching is like looking for a word in a dictionary when you do not know how the word is spelled.

I have ran into that before. . .I did not know the correct search word so I ended up in vicious circle, not getting ahead with the job.

Of course I realise that this is like attempting to fix an engine if you have no idea how an engine works.

I will look at “Empty Cell” representation

Maybe EMP already exits as the correct answer. . .I will try it

No! It does not work

Still searching. . . . .tra la la. . .