OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)
-   -   calling computer buffs (http://forums.ozmium.com.au/showthread.php?t=31233)

partypooper 27th September 2016 04:50 PM

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

partypooper 27th September 2016 05:05 PM

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

walkermac 27th September 2016 05:24 PM

In cell AA2:

=if(s2=0,1,0)

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

partypooper 27th September 2016 05:25 PM

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

partypooper 27th September 2016 05:31 PM

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

walkermac 27th September 2016 05:43 PM

Quote:
Originally Posted by partypooper
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?)

partypooper 27th September 2016 05:51 PM

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?

partypooper 27th September 2016 05:55 PM

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

Chad328 28th September 2016 08:13 AM

Glad this one got sorted,


All times are GMT +10. The time now is 07:59 PM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.