| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make them work on the Each cell Value
Hello from Steved
in Cell A1 I have 5854, now picking up the first digit which is 5 it will type in "Shore" Please how do I ask the bottom Formulas to do this please =IF(LEFT(A2,1)="1","City","")+=IF(LEFT(A2,1)="2"," Roskill","") as this method leaves me a true or false . =IF(LEFT(A2,1)="1","City","") =IF(LEFT(A2,1)="2","Roskill","") =IF(LEFT(A2,1)="4","Wiri","") =IF(LEFT(A2,1)="5","Shore","") =IF(LEFT(A2,1)="6","Orewa","") =IF(LEFT(A2,1)="7","Swanson","") =IF(LEFT(A2,1)="8","Panmure","") Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
| Cant make it work | New Users to Excel | |||
| can't make it work, I need help | Excel Worksheet Functions | |||
| How can i make this work within an IF statement: (41<=Cell<=46) | New Users to Excel | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
Threaded Mode
