Thread: Excel formular
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Excel formular

It's not really clear what you are trying to do.
Are you testing for no zero value in any of the cells A1 to E1

Maybe this,
=IF(COUNTIF(A1:E1,"0")0,F2+1,0)

HTH
Martin


"Linda" wrote in message
...
I need help with a simple question: what is the formular for not equal to
0?
I need to have a formular for =IF(A1:E1 not equal to 0,F2+1,0). Please
help.

Thank you,
Linda