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

[Closed]
Report
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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 ""