| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF formulas
I am trying to create formula in cell L2 that reflectes 3 bids. The formula
I am use works at 2 levels not 3. This is the formula I am using =if(s2<=J2,p2)=if(w2<=j2,t2)=if(aa2<=j2,x2). Steps 1 & 2 are false, 3 is ture but I get a #vaule in the field. What am I missing in the multiple step formula? I want to be able to select the contractor that is less than or equal to my approved dollar amount. thanks, -- Debmil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple IF formulas | Excel Discussion (Misc queries) | |||
| How do you use multiple if formulas with multiple choices? | Excel Worksheet Functions | |||
| Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
| Multiple if/then, OR formulas | Excel Discussion (Misc queries) | |||
| Sort multiple columns with multiple formulas without returning #R | Excel Worksheet Functions | |||
Threaded Mode
