| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help Needed! Using complex IF function
Not sure whether =IF function is the correct on to use, but I need to test on values in column A, to see if the value is 1500 more (+) or less (-) than values in column B. I would also like to get an output in column C, so that if the result is "true" then a number "3" can be attributed for coding purposes
Please find an example of the data below; A B 97081 21082 20825 21075 94347 21068 92611 21064 90761 21063 89252 21079 87686 21103 85975 21121 84529 21140 82294 21161 80661 21184 78868 21208 77240 21234 75546 21264 73510 21295 72018 21328 70542 21361 68904 21406 67779 21452 66134 21500 64702 21535 63281 21580 Thanks in advance John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A complex formula, help needed | Excel Worksheet Functions | |||
| Complex function needed? | Excel Worksheet Functions | |||
| Help needed with setting up a complex directive | Excel Programming | |||
| Complex formula help needed | Excel Worksheet Functions | |||
| Complex forumula help needed | Excel Worksheet Functions | |||
Threaded Mode
