Can an if then formula be done for this?

[JeffinSC]

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

 

[Anne Troy]

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/vlookup_formulas_in_microsoft_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