Nested IFs to pad numbers with zeroes
Joseph Prespare
I am looking to pad a columns with zero's so that I can later concatenate it's value. It needs to 4 characters, so I am trying to use a Nested If Statement.
=IF(LEN(G2)=3,"0" & G2),IF(LEN(G2)=2,"00" & G2,G2)
I only get '#Value'. Where am I going wrong?
Jean-François Corbett
Don't reinvent the wheel: there is already a built-in function do to this.
=TEXT(G2,"0000")
Now, to answer your question specifically, the reason you got your error was that your IF functions weren't properly nested due to misplaced right brackets ).
Was:
=IF(LEN(G2)=3,"0" & G2),IF(LEN(G2)=2,"00" & G2,G2)
^
Should be:
=IF(LEN(G2)=3,"0" & G2,IF(LEN(G2)=2,"00" & G2,G2))
^
Still, this won't give you the expected results. Just go with the built-in TEXT function.
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
에서 수정
- 이전 게시물：JBoss 5.1.0.GA-작동하지 않는 포트 443으로 리디렉션, 항상 8443으로 리디렉션 됨
- 다음 포스트：Node: zlib.gunzip works, but not zlib.inflate?
관련 기사
Related 관련 기사
- 1
simplifyfing a lot of ifs for numbers range folder check
- 2
How can I zero-pad numbers in a Batch FOR loop?
- 3
Matching numbers inside nested numbered groups
- 4
Strip zeroes with regex in csv file
- 5
JavaScript의 SUM IFS
- 6
IFS 이해
- 7
Matching fixed number of zeroes before new line
- 8
ARP messages padding with zeroes.. sometimes
- 9
Where does my leading zeroes go?
- 10
Overwriting the whole disk with zeroes (bad sectors)
- 11
IFS 문자 인쇄
- 12
Google Script IFS 조건
- 13
UNIX (AIX) Version of IFS <<< command
- 14
Bash IFS is ignoring the delimiter at the end of line
- 15
'IFS'는 무엇입니까?
- 16
"IFS = read -r line"이해
- 17
여러 ifs bash 결합
- 18
read -r vs read -r line and IFS
- 19
Is arithmetic expansion related to IFS in some way?
- 20
"for 루프"에서 IFS 사용
- 21
Using regex with IFS variable to split Bash string
- 22
쉘이 IFS = $ '\ n'를 IFS = 'n'으로 해석합니다.
- 23
널 IFS에 대해 기본 IFS 테스트
- 24
Glide Pad "Smooth Scroll"감지
- 25
How can i pad the edges of a rectangle with points?
- 26
reduce laptop touch pad sensitivity in ubuntu
- 27
Clear definition for the PHP str_pad() Function
- 28
SQLite에 해당하는 SUM IFS
- 29
셸, IFS, 읽기 및 표 작성
몇 마디 만하겠습니다