need a formula

[Louis]

If column N has a number greater than 0.0 and but there
are 0.00 in columns G, H, I and J, then I need to have the
message "Don't Update".

Please help with this formula, there are over 50,000 rows
of data.

Thank you

Louis

 

[Suresh Nair]

=IF(AND((N3)>0,(G3)=0,(H3)=0,(I3)=0,(J)=0),"Don`t
Update","plsupdate")

HTH

 

[Louis]

-----Original Message-----
=IF(AND((N3)>0,(G3)=0,(H3)=0,(I3)=0,(J)=0),"Don`t
Update","plsupdate")

HTH
.
THANK YOU