| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
multiple if
I need to create a formula that outputs a 1, 2, or 3 based on the result of:
If the value of x-y <10 then cell B3 = 1, If the value of x-y<10 but 15 then cell B3 = 2, If x-y<15 then cell B3 = 3. Can I do this with formulae or do I need to go to VBA, if I need to go to VBA how is this calculated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show multiple worksheets on multiple screens? | Excel Discussion (Misc queries) | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
| multiple entries | Excel Worksheet Functions | |||
Threaded Mode
