| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help reducing this long nested functuion?
I was making a binary converter in Excel 2007, a challange from my teacher,
and I found that using multiple IF functions inside a TEXT function I can turn a group of cells into one data entry. The full function is: =TEXT(IF(C8=1,C8&D8&E8&F8&G8&H8&I8&J8&K8&L8&M8,IF (D8=1,D8&E8&F8&G8&H8&I8&J8&K8&L8&M8,IF(E8=1,E8&F 8&G8&H8&I8&J8&K8&L8&M8,IF(F8=1,F8&G8&H8&I8&J8&K8& L8&M8,IF(G8=1,G8&H8&I8&J8&K8&L8&M8,IF(H8=1,H8&I8 &J8&K8&L8&M8,IF(I8=1,I8&J8&K8&L8&M8,IF(J8=1,J8&K 8&L8&M8,IF(K8=1,K8&L8&M8,IF(L8=1,L8&M8,M8))))))) ))),0) The refernces refer to the 10 cells in which digits of a number can be stored and the IFs are used to stop 0s being placed in front of the digits=1. I had to use all of the & signs because the TEXT function wouldn't recognise entries such as C8:M8, and I wanted to reduce the number of IF functions so it would save as a 2003 file. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
| Long Long Long Nested If Function | Excel Discussion (Misc queries) | |||
| Nested IF too long - other suggestions? | Excel Worksheet Functions | |||
| Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
| Date functuion. | Excel Worksheet Functions | |||
Threaded Mode
