T
Timmy
If the value of column B is greater by 2 than the value of column A, Record
as 1 in column C.
as 1 in column C.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bill Kuunders
enter in C2
=IF(B2-A2>2,1,"")
and copy down
=IF(B2-A2>2,1,"")
and copy down
T
Timmy
Thanks for your help Bill, Im in NZ too!!!
Unfortunatly your formula did not work. It doesnt show up as invalid but
just turns up a blank(not a zero even) in the C column.....Help!!!
Unfortunatly your formula did not work. It doesnt show up as invalid but
just turns up a blank(not a zero even) in the C column.....Help!!!
R
Roger Govier
Try
=IF(B2-A2>=2,1,"")
to pick up when the difference is actually 2
=IF(B2-A2>=2,1,"")
to pick up when the difference is actually 2
T
Timmy
Great!!!!thats it!! Now Can I enter more than one function like this in the
same formula to keep building my total ....something like:
=IF(B2-A2>=2,1,"") + (B3-A3>=2,1,"") + ........and so on, so my result of 1
would keep tallying 1+1+1+1 = 4
same formula to keep building my total ....something like:
=IF(B2-A2>=2,1,"") + (B3-A3>=2,1,"") + ........and so on, so my result of 1
would keep tallying 1+1+1+1 = 4
B
Bill Kuunders
Timmy
From your first reply
it looked like you want a 0 result if not >=2.
This can be done with =IF(B2-A2>=2,1,0)
With copy down I indicated that you can extend the formula down the column.
Use the right hand bottom corner of C2 cell
The mouse pointer changes to a black "+" sign
hold and drag down
You can then add the results in that column.
Regards
Bill K
From your first reply
it looked like you want a 0 result if not >=2.
This can be done with =IF(B2-A2>=2,1,0)
With copy down I indicated that you can extend the formula down the column.
Use the right hand bottom corner of C2 cell
The mouse pointer changes to a black "+" sign
hold and drag down
You can then add the results in that column.
Regards
Bill K