View Single Post
  #1   Report Post  
Jenny
 
Posts: n/a
Default nesting 18 x functions

Help, anyone?
I am trying to nest 18 x IF functions to automatically pick up a text value
for a numeric result. I have ranked 18 x actual values in 3 x cell in a
column for my top 3 x performers (value of sales). what I now want to do is
on the next row have the name of that person appear under that specific
ranking number according to the actual sales (so I don't need to scroll up to
see who produced that value). Nesting only allows me 7 x IF's. Help anyone
???