| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining formulas
My bad ... I figured it out.
Thanks again! -- Krista "Krista" wrote: Yes, that's what I mean -- thanks. I tried this formula; however, nothing is appearing. I initially thought that's what the formula should be; however, it's not calculating ... the field is blank. Thanks. -- Krista "SteveG" wrote: Krista, Do you mean if the first 3 characters are "12x" or first 2 are "6x"? Try, =IF(E33="","",IF(LEFT(E33,3)="12x",F33*0.7*0.8,IF( LEFT(E33,2)="6x",F33*0.7*0.5,0))) HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=552424 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
| How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
| combining countif formulas | Excel Worksheet Functions | |||
Hybrid Mode
