LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
???
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PivotTable canned functions doco Excel Discussion (Misc queries) 0 January 14th 05 03:52 PM
Changing the language of built-in functions? Gustaf Liljegren New Users to Excel 3 December 20th 04 08:31 PM
How to load Engineering Functions into the Fx function wizard? jsaval Excel Worksheet Functions 1 November 11th 04 09:47 PM
AND and IF Functions fosterp Excel Worksheet Functions 2 November 10th 04 05:36 PM
Where can I see VBA code for financial functions? eios Excel Worksheet Functions 1 November 2nd 04 01:00 PM


All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"