Difference between numbers

[yappers]

HI
I have a question about using IF and having the true result be anothe
formula. I am trying to take the difference between two number
(scores) and compare to a third (football spread) and have the tru
result be replace an x with a 1 so that correct picks can b
automatically summed.
Here is the formula I am using and can only get "Replace...." to sho
up in the cell where the formula is. Is there a way to get it t
change the x with a 1 in other cells? I have the formula below in D
which is a column I added just to put the formulas in I intend to hid
this column.
Do I make any sense?
Any help would be appreciated.

=IF(B2-B3>c2,"=replace(F2:V2,X,1)",0

 

[RagDyeR]

Formulas only control the cell that they're in.

You can, however, place formulas in F2:V2, which can display any characters
or numbers that you wish, depending on the calculation results between B2
and B3 and C2.

Here's a guess on my part, for what I think you're looking for.
Enter this in F2:

=IF(OR( B2="",B3=""),"X",IF(B2-B3>C2,1,0))

I can't tell from your post which way you're data list is entered, so
copying this formula across the columns will return errors.

If it's not correct, post back with what you would like to exactly be
displayed in F2:V2, under *all* different conditions between B2 and B3, and
also,
are you polling down the column,
and is C2 a constant?

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



HI
I have a question about using IF and having the true result be another
formula. I am trying to take the difference between two numbers
(scores) and compare to a third (football spread) and have the true
result be replace an x with a 1 so that correct picks can be
automatically summed.
Here is the formula I am using and can only get "Replace...." to show
up in the cell where the formula is. Is there a way to get it to
change the x with a 1 in other cells? I have the formula below in D2
which is a column I added just to put the formulas in I intend to hide
this column.
Do I make any sense?
Any help would be appreciated.

=IF(B2-B3>c2,"=replace(F2:V2,X,1)",0)

 

[Don]

This might work for you if you only have two values of "X"
in your formula. Assume those two values are "1" and "2".

Put "1" in D3 and "2" in D4

In D2 put...

=IF(B2-B3>C2,D3,D4)

Then call "D2" into your formula.

HTH,

Don