Difference between numbers

[yappers]

A B C D
E F
Score Spread Visitor Beau Ever
Sun 0 3.5 Denver 0 0
10am 0 0.0 JACKSONVILLE 1
Sun 0 4.5 Pittsburgh 0 0
10am 0 0.0 BALTIMORE 0
Sun 10 3.5 Houston
10am 2 0.0 DETROIT 1


Here is my layout.

This is sheet two where I am going to have all the math happen and the
import back into sheet one. There are spaces in the sheet for totalin
the morning and afternoon games. On sheet one colmns E and above ar
peoples names and their respective picks are marked with an x so sheet
looks something like this:

A B C D
E F
Score Spread Beau Ever
Sun 3.5 Denver X X
10am JACKSONVILLE
Sun 4.5 BALTIMORE X
10am Pittsburgh X
Sun 10 3.5 DETROIT X X
10am 2 Houston
Sun 1.5 TENNESSEE X
10am Indianapolis X


I am trying to take the diference of the scores and compare to th
spread and if the favorite covers the spread then on sheet two take th
x on sheet one and replace with a 1 if not replace with a 0. th
formula I am using for this is =IF(AND(B2-B3>C2,Sheet1!E2="X"),1,0).

My new problem is that the formula for the under dog:
=IF(AND(Sheet1!E3="x",B2-B3<C2),1,0)

returns a 1 when sheet 1 is empty. I cannot figure a way to tell i
that unless there are scores in column b that it should return a zero.

The or statement worked but I need to signify that that column mus
have an X in it before returning a number.

Sorry for the long post but I think this should show what I am tryuin
to do.

Also the spread sheet does not show right in the pos

 

[Biff]

Hi yappers!

=IF(AND(Sheet1!E3="x",B2-B3<C2),1,0)

I cannot figure a way to tell it that unless there are
scores in column b that it should return a zero.

You can add a test condition for cells B2, B3 or either
one.

=IF(AND(Sheet1!E3="x",B2<>"",B3<>"",B2-B3<C2),1,0)

Biff