Can someone please help me to set up a conditional formula? I don't have much experience with these. Basically, what I am trying to achieve is...
Column C has a drop down to select Yes, Partial, or No.
Column D needs to provide a number depending on which of the above is selected (Yes=1, Partial=0.5, No=0)
Can this be done?Thank you
Formula:
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi salty_suz. Welcome to the forum.
Try:
Dave
Thanks Dave, perfect solution! Appreciate the help.
You're welcome. Looks like humdingaling beat me to it, though.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Last edited by FlameRetired; 10-11-2018 at 12:21 AM. Reason: Note about marking Solved
Or can try
Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks