How do I accomplish this? I keep getting errors.
I have a drop down of Not Started, In Work, Completed in C4
and in C3 I want a percentage to match 0%, 50%, 100% respectfully.
And I want this to work for the whole columns.
Thanks!
How do I accomplish this? I keep getting errors.
I have a drop down of Not Started, In Work, Completed in C4
and in C3 I want a percentage to match 0%, 50%, 100% respectfully.
And I want this to work for the whole columns.
Thanks!
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Here is an example of what I want it to look like.
=IF(C1="Not Started",0%,IF(C1="In Work",50%,IF(C1="Completed",100%)))
Copy the formula in B1
Punnam
Try lookup instead...
Formula:Please Login or Register to view this content.
Don't forget to click *
Try lookup instead...
Formula:Please Login or Register to view this content.
Don't forget to click *
Hi,
If your question answered. Mark the thread solved by using the thread tool.
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks