View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default If/and functions

Just to be different form the rest<g, put this in A1 and copy down...

=ABS(A1=0.18)


Actually, I'm not sure why I chose to use the ABS function; this should be
quicker (because it doesn't use a function call at all)...

=--(A1=0.18)

Note: There are two minus signs in front of the left parenthesis.

Rick