Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 27th September 2016, 04:50 PM
partypooper partypooper is offline
Member
 
Join Date: Nov 1999
Location: Western Australia
Posts: 2,383
Default 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
Reply With Quote
  #2  
Old 27th September 2016, 05:05 PM
partypooper partypooper is offline
Member
 
Join Date: Nov 1999
Location: Western Australia
Posts: 2,383
Default

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
Reply With Quote
  #3  
Old 27th September 2016, 05:24 PM
walkermac walkermac is offline
Member
 
Join Date: Nov 2013
Posts: 596
Default

In cell AA2:

=if(s2=0,1,0)

(presuming s2 can only contain the values 0 or 1)
Reply With Quote
  #4  
Old 27th September 2016, 05:25 PM
partypooper partypooper is offline
Member
 
Join Date: Nov 1999
Location: Western Australia
Posts: 2,383
Default

yes thanks for that, I'll give it a go
Reply With Quote
  #5  
Old 27th September 2016, 05:31 PM
partypooper partypooper is offline
Member
 
Join Date: Nov 1999
Location: Western Australia
Posts: 2,383
Default

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
Reply With Quote
  #6  
Old 27th September 2016, 05:43 PM
walkermac walkermac is offline
Member
 
Join Date: Nov 2013
Posts: 596
Default

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?)
Reply With Quote
  #7  
Old 27th September 2016, 05:51 PM
partypooper partypooper is offline
Member
 
Join Date: Nov 1999
Location: Western Australia
Posts: 2,383
Default

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?
Reply With Quote
  #8  
Old 27th September 2016, 05:55 PM
partypooper partypooper is offline
Member
 
Join Date: Nov 1999
Location: Western Australia
Posts: 2,383
Default

walkermac, cancel that just tried it again and its all good, thanks heaps!
Reply With Quote
  #9  
Old 28th September 2016, 08:13 AM
Chad328 Chad328 is offline
Member
 
Join Date: Aug 2016
Posts: 6
Default

Glad this one got sorted,

Last edited by Moderator 4 : 28th September 2016 at 08:30 AM.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 06:26 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655