Hi guys, I have a quick question:
When I use this formula: =IF([[TIPO ]]="DEPOSITO",TEXT(ROW(C1),"C - 000"),"NULL") there's no problem, but when I change the letter C in "C - 000" for D, =IF([[TIPO ]]="DEPOSITO",TEXT(ROW(C1),"D - 000"),"NULL") I get a #Value! Error
Any Help?
Last edited by adalbertobf; 06-21-2016 at 11:42 AM.
Hi, welcome to teh forum
Hard tio say what the problem might be without seeing a sample of what you are working with. I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi! Thank for the quick response admin! Attachment uploaded. Thank you!
Hello adalbertobf,
Welcome to the forum
If you only want to change the Letter part, change your formula to this instead
C3:
And you can change "D" to "C" or "E" or even "Today is a great day (maybe)" and it should run just fine.
Please Login or Register to view this content.
idk why the "C - 000" actually works as a text_format, it'd be great if someone can explain that too xd
(copy pasta from Ford)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
Regards,
Lem
Interesting...
=TEXT(ROW(C1),"C - 000")
works but
=TEXT(ROW(C1),"D - 000")
does not.
I will push this out to the other experts to see if they know why
Because D is one of the built-in formatting codes (for Day). You need to escape it either with a backslash or quotes:
=TEXT(ROW(C1),"\D - 000")
or:
=TEXT(ROW(C1),"""D"" - 000")
This works to perfection! Thank you Rorya!
Good to know, Rory, thanks for the assist
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks