Thread: How do you use more than 7 arguments in a logical IF?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default How do you use more than 7 arguments in a logical IF?
http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bill" wrote in message ...
|I am able to utilize a logical IF to automatically select the data I want to
| show in a cell based on the result of the logical IF statement. My problem
| is that I want to exceed the apparent limit of 7 nested IF's. The result
| must show up in a speciofic cell.
| I could utilize several cells (on a different worksheet) to all reference
| the data in a specific cell and then use a seperate cell to query the result
| of the cells but that is where I get confused.


Reply With QuoteReply With Quote