Can an if then formula be done for this?
 

If the value of F1-F2 is = to or between 5 and 9 add 1 to cell A1
If the value of F1-F2 is = to or between 10 and 14 add 1 to cell A1 and
1 to Cell B1
If the value of F1-F2 is = to or between 15 and 19 add 2 to cell A1 and
1 to cell B1
If the value of F1-F2 is = to or greater than 20 add 2 to cell A1 and 2
to cell B1.
If the value of F1-F2 is = to or between -5 and -9 subtract 1 from cell
A1
If the value of F1-F2 is = to or between -10 and -14 subtract 1 from
cell A1 and subtract 1 from cell B1
If the value of F1-F2 is =to or between -15 and -19 subtract 2 from
cell A1 and subtract 1 from cell B1.
If the value of F1-F2 is = to or less than -20 subtract 2 from cell A1
and 2 from cell B1

For values between -4 and 4 I would want no changes.

Can this be done? I am new to Excel.

Thanks,
Jeff


--
JeffinSC
------------------------------------------------------------------------
JeffinSC's Profile: http://www.excelforum.com/member.php...o&userid=30617
View this thread: http://www.excelforum.com/showthread...hreadid=502708

Can an if then formula be done for this?
 

Yes. The best way I could show you was to just do it. IF formulas would be
pretty tough, so I used a VLOOKUP, which would allow you to change the
values if you wanted at any time.
See: www.officearticles.com/downloads/sampleIFs.xls and also
http://www.officearticles.com/excel/...soft_excel.htm
for how to name the range, etc. Your lookup table does NOT have to be on the
same sheet, and you can even hide it if you want.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"JeffinSC" wrote in
message ...

If the value of F1-F2 is = to or between 5 and 9 add 1 to cell A1
If the value of F1-F2 is = to or between 10 and 14 add 1 to cell A1 and
1 to Cell B1
If the value of F1-F2 is = to or between 15 and 19 add 2 to cell A1 and
1 to cell B1
If the value of F1-F2 is = to or greater than 20 add 2 to cell A1 and 2
to cell B1.
If the value of F1-F2 is = to or between -5 and -9 subtract 1 from cell
A1
If the value of F1-F2 is = to or between -10 and -14 subtract 1 from
cell A1 and subtract 1 from cell B1
If the value of F1-F2 is =to or between -15 and -19 subtract 2 from
cell A1 and subtract 1 from cell B1.
If the value of F1-F2 is = to or less than -20 subtract 2 from cell A1
and 2 from cell B1

For values between -4 and 4 I would want no changes.

Can this be done? I am new to Excel.

Thanks,
Jeff


--
JeffinSC
------------------------------------------------------------------------
JeffinSC's Profile:
http://www.excelforum.com/member.php...o&userid=30617
View this thread: http://www.excelforum.com/showthread...hreadid=502708