Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |