View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default IF - not equal to

Glad you got it sorted out ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"j.jansson" wrote in message
...
Ok, i found the problem. The "0" were not a number, excel thought it was
text
and when i added the " " around 0 I got the answer i was looking for.

/J