IF Formula 1

[Suggie]

Morning,

Having trouble working out an if formula, trying to find out if cells a1, a2, and a3 all contain the same values, e.g. that all have the number 5 in each cell, then return yes or no.

any ideas?

tia

 

[shetlandbob]

post what youve got and we can point out where your going wrong

Robert Cumming

http://www.consultantengineer.co.uk

 

[GlennUK]

Hi Suggie,

this will give TRUE if all are the same:

=AND(A1=A2,A2=A3)


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Suggie]

Thanks Glenn, that's the trick. Appreciate it. Mark

 

[TonyJollans]

Perhaps more generally ..
[blue][tt] =IF(SUMPRODUCT((A1:A3<>A1)*1)>0,"no","yes")[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[GlennUK]

My pleasure.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.