| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement help
A B C
8 2 1 In column C I have the following =IF(A27,1,IF(A2=6,2,IF(A2=3,3,IF(A2=1,4,5)))) which is working for me however I would like this formula to also perform the following. If cell B2 0 i want it to subtract 1 from the result (the actual number in C should be a zero) Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement nightmare | Excel Discussion (Misc queries) | |||
| What statement to use? | Excel Worksheet Functions | |||
| Statement | Excel Worksheet Functions | |||
Threaded Mode
