![]() |
calling computer buffs
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 |
Quote:
|
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,
|
All times are GMT +10. The time now is 10:58 PM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.