| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiple IF
I need to check column A for the following:
1) IF A11<9999 then A1 2) IF A1<0 then 0 3) IF A110000 then 10000 A B 1 4,576 4,576 2 (6,719) 0 3 14,699 10,000 Column B is the results I want. How can I get this in one formula? Thanks Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
Threaded Mode
