In L7: IF(K7="","",IF(K7>"",IF(OR(K7="a",K7="d",K7="n"),7,7.5)))
I do have one question about the following: > In cell Y7 if d appears in K7 M7 O7 count as 1 > In cell Z7 if A appears in K7 M7 O7 count as 1 Should it count as 1 if all three columns are 'd' or is it either one, two, or all three? Thanks Nauman Khan On Nov 30, 9:23 pm, Zilla <zill...@gmail.com> wrote: > I am stumped with this one I have to do for work. > I have been trying to achieve the following without any luck. > This is what I would like. > > In cell W7 If cells K7 M7 O7 = the letter d,a,n, or b count as 1 > > In cell L7 I would like if d a n appear in k7 show as 7 if the letter > b is in K7 show as 7.5 > > In cell Y7 if d appears in K7 M7 O7 count as 1 > > In cell Z7 if A appears in K7 M7 O7 count as 1 > > I have provided a snap shot of the spreadsheet. > > Any help would be appreciated. I guess I have been at it to long today > and my brain is not functioning. > > http://imgur.com/jOZKT.jpg -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
