View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aussie Barbie Aussie Barbie is offline
external usenet poster
 
Posts: 1
Default MS Excel Nested Functions

Hello,

I want to nest more than 7 nested functions (actually I woould like to do
about 14 or more. Is this possible?

I have listed a sample of what I have to date but cannot seem to get any
more. Can you help?

=IF($C$11<=10000,C24,IF($C$11<20001,D24,IF($C$11<3 5001,E24,IF($C$11<50001,F24,IF($C$11<75001,G24,IF( $C$11<100001,H24,IF($C$11<150000,I24,IF($C$111499 9,J24))))))))