Hello all, can anyone help me with a formula? I want cell "b" to read 0 if cell "a" is 1 and cell b to read 1 if cell "a' is 0

to be more specific I actually need this: if s2 shows 0 then AA2 shows 1, and if s2 shows 1 then AA2 shows 0

In cell AA2:

=if(s2=0,1,0)

(presuming s2 can only contain the values 0 or 1)

yes thanks for that, I'll give it a go

I think I entered that correctly, but whats happening is that when s2 is 1 AA2 is also showing 1, what I need is for AA2 to be showing 0, BUT ALSO when s2 is 0 THEN AA@ shows 1,

I think I made that sound difficult?

in other words I want AA2 to show the opposite of s2

That's what it does. Tested it here and it works as expected, so you might have to check you're putting everything in the correct cells (does AA2 change at all?)

yes, s2 is showing 1, but AA2 is also showing 1 instead of 0, by the way this is a "works' spreadsheet not Excel could that be the problem?

walkermac, cancel that just tried it again and its all good, thanks heaps!

Glad this one got sorted,