Good Morning All,
I have a spreadsheet which contains information about documents. Column D contains the documents revision and column G contains the current document status.
Document revisions are as follows
A1, A2 etc = Internal Review
B1, B2 etc = Client Review
C1 C2 etc = Issued for Use.
I was wondering if I could get Column G to automatically populate with "Internal Review" for example if I entered A(x) into column C - (x being the number of revisions at that status)
try in column G1
=IF( Left(C1,1)="A", "Internal Review", "what you want to put if not A")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thats Excellent, Cheers Etaf.
I'm very unsure of the syntax and arguments when it comes to formulas. Can I extend this to include the B = Client Review and C = Issued for Use?
=IF( LEFT(D2,1)="A", "Internal Review", IF( LEFT(D2,1)="B", "Client Review", IF( LEFT(D2,1)="C", "Issued for Use", "Enter Status")))
Managed to use nested if statements to achieve this.
Thanks for all your help!
=IF( Left(C1,1)="A", "Internal Review", IF(Left(C1,1)="B", "Client Review" , "Issued for Use"))
the above assumes you only have A(x), B(x) or C(x) entered and not other characters will be used in the cell
essentially if the cell 1st character is not an A or B it will put "Issued for Use"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks