ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   IF STATEMENT (https://www.excelbanter.com/excel-discussion-misc-queries/124628-if-statement.html)

Daniel

IF STATEMENT
 
Does anyone know if it is possible to create an IF statement longer than a
string of 7 arguements, if so how?

Niek Otten

IF STATEMENT
 
Look he

http://www.j-walk.com/ss/excel/usertips/tip080.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Daniel" wrote in message ...
| Does anyone know if it is possible to create an IF statement longer than a
| string of 7 arguements, if so how?



Geoff Ness

IF STATEMENT
 
It's not possible to nest more than 7 IF statements, but there are
workarounds. One can be found at http://www.cpearson.com/excel/nested.htm

and another at http://www.grbps.com/ExcelA.pdf

Hope this helps

Daniel wrote:
Does anyone know if it is possible to create an IF statement longer than a
string of 7 arguements, if so how?



All times are GMT +1. The time now is 07:37 PM.

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