I am looking for a formula able to cover the following:
If (B6=Y, and B7=N, then B8), if (B6=Y and B7=G, then B9), otherwise 0.00
Basically
if John answered yes to question 1, and no to question 2....we get result no 1
if John answered yes to question 1, and yes to question 2....we get result no 2
Otherwise we get 0.00
Hope that make sense.
Thanks
Mark
why not just count the "Y" with countif formula?
means if you have 10 questions you don't have to write 10 IF statements?
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.
If humding's suggestion does not work for you, 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks