Recording an outcome when no data in the field, how to stop?

Closed
Joshte Posts 3 Registration date Thursday March 7, 2013 Status Member Last seen March 9, 2013 - Mar 9, 2013 at 02:34 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 10, 2013 at 10:46 AM
Hello,
I am making a basketball spreadsheet to record "Wins ATS Favorites", "Over/under", and "Wins SU".
I use the If((b6-c6)>d6; 1), where "b6" is points by the favorite, "c6" is the spread, and "d6" is the points scored by the underdog.
It works fine when the data is in the fields.
But, when there is no data in b6 and d6, game not played and there is data in c6, like now, because I am analyzing for today's game, the "Win ATS Favorites" column would show 7 in the ties column, distorting my focus.
How can I get the columns to only record outcome when all fields are full?
Thanks



1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Mar 10, 2013 at 10:46 AM
You question is showing that you know what to do. If you think about it, you are talking about two IF, one if columns are blank and other for spread

=IF(condtion, <when true>, <when false>)

your if statement can have seven ifs embedded

=IF(cond1, If(cond2, <true cond1 and 2>, <true cond1 and false cond2), <false cond 1)

ok so much for teaching to fish, now to part of giving fish
=IF(AND( b6 <>""; d6,<>""; c6 <>""),If((b6-c6)>d6; 1); "")

what formula is saying is

if B6, C6 AND D6 are not equal to "" then use your if logic

if any one of B6,C6 or D6 is equal to "", then just show ""
0