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/...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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>