| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF + AND string - Help!
if(and(i4<1500,i41400),1.039, if(and(i4<1400,i41300), 1.082, if(i4<1300,i41200),1.132, if(and(i4<1200,i41100),1.185,if(and(i4<1100,i410 00),1.262,1)))) I'm getting an error indicator at *1.132*. I thought I could nest 7 IF statements together? What am I missing? -- BigDave ------------------------------------------------------------------------ BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741 View this thread: http://www.excelforum.com/showthread...hreadid=471726 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up a string of text within a string of text | Excel Worksheet Functions | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Threaded Mode
