I have a spreadsheet with a filed that only gets populated infrequently. I need it so that when this field gets populated it takes that value and in the cell next to it appends a value xyz.555
For example if a user inputs 5552223333 the next cell over will display 5552223333xyz.555 but if the user skips that field the cell next to it would be blank. I have the value xyz.555 as a hidden value to reference in formulas (Cell T1)
Perhaps this?
=if(A1="","",A1&xyz.555)
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
I take it that worked for you, so thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks