| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Return value with using Excel function
Use a function : =IF(AD3="","",VLOOKUP(AD3,Table!$E$2:$G$450,3,0)), return
value in cell AE3 e.g. = 03 My problem: Try posting this value to another cell using this function: =IF(AE3<10,IF(AE3="","","50-0"&AE3&"-"&AB3&"-790-50026-0000"),IF(AE3="","","50-"&AE3&"-"&AB3&"-790-50026-0000")) The return value always truncated the preceeding zero if I do not use the last function I I know this is not proper. Any good suggest from the Pro thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Will the Excel WEEKNUM function become ISO 8601 compliant? | Excel Worksheet Functions | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| Missing function in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
