View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Eddie Eddie is offline
external usenet poster
 
Posts: 30
Default if a1=b1=c1=d1....

I have always found nested if statements quite useful

=IF(A1=B1,IF(A1=C1,IF(A1=D1,"true","false")))


"Jshendel" wrote:

is it possible to have this type of equation?
=if(a1=b1=c1=d1,"true","false")
I don't want to just find the sum of these cells because there may be other
instances where they do equal a sum, but are not equal to each other.
1 1 1 1 (right)
4 0 0 0 (wrong)