Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change 4 to Wiri
Hello from Steved
In Col A1 I've got 4517 in Col E1 I need a formula please That will Change Col A1 to Wiri. Yes I know how to do it but I just can't think at this time, how to do it. I Thankyou. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change 4 to Wiri
A formula can only change the cell it is in, so there is no formula you can
put in E1 that will change a constant value in cell A1. There may be other ways to do what you want, but you will have to provide more information (such as how the 4517 got into A1 and what is supposed to happen in E1 to make A1 change). -- Rick (MVP - Excel) "Steved" wrote in message ... Hello from Steved In Col A1 I've got 4517 in Col E1 I need a formula please That will Change Col A1 to Wiri. Yes I know how to do it but I just can't think at this time, how to do it. I Thankyou. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change 4 to Wiri
so you want 4517 in a1 and wiri will populate in e1. is this as far it goes
or there over 3's in a1 that need to yeild a diiferent word is so you need vlookup and then a good sortable table array is not just use a simple if formula "Steved" wrote: Hello from Steved In Col A1 I've got 4517 in Col E1 I need a formula please That will Change Col A1 to Wiri. Yes I know how to do it but I just can't think at this time, how to do it. I Thankyou. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change 4 to Wiri
This newsgroup is for people who post in English. There are lots of other
groups for other languages. Regards, Fred. " wrote in message ... so you want 4517 in a1 and wiri will populate in e1. is this as far it goes or there over 3's in a1 that need to yeild a diiferent word is so you need vlookup and then a good sortable table array is not just use a simple if formula "Steved" wrote: Hello from Steved In Col A1 I've got 4517 in Col E1 I need a formula please That will Change Col A1 to Wiri. Yes I know how to do it but I just can't think at this time, how to do it. I Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change formula in shared sheet without loss of change histo | Excel Worksheet Functions | |||
change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions |