Excel formular
 

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

Excel formular
 

On Jan 16, 7:26 pm, Linda wrote:
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

=if(A1<0,F2+1,0)

Excel formular
 

Maybe this............

=IF(SUM(A1:E1)<0,F2+1,0)

Vaya con Dios,
Chuck, CABGx3


"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

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