ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do you enter more than 7 "if" functions in a formula? (https://www.excelbanter.com/excel-worksheet-functions/81922-how-do-you-enter-more-than-7-if-functions-formula.html)

Heindrich

how do you enter more than 7 "if" functions in a formula?
 


Niek Otten

how do you enter more than 7 "if" functions in a formula?
 
http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten

"Heindrich" <Heindrich @discussions.microsoft.com wrote in message ...




Heindrich

how do you enter more than 7 "if" functions in a formula?
 
thank you... That helps alot.

"Niek Otten" wrote:

http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten

"Heindrich" <Heindrich @discussions.microsoft.com wrote in message ...





MattShoreson

how do you enter more than 7 "if" functions in a formula?
 

TIP: try not to use too many nested ifs.
They are very nasty to debug if they go wrong.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=530503



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com