IF FUNCTION
Why excel only allow us to create max 7 if fuction in one formula.
How to manage if we want more .. Thanks guys |
IF FUNCTION
Hi
"Lando" wrote in message ... Why excel only allow us to create max 7 if fuction in one formula. How to manage if we want more .. There are a lot of ways - it depends on your data and on your preferences, which one to use: a) Use a lookup table and LOOKUP/VLOOKUP/INDEX/CHOOSE/SUMPRODUCT to return a value from there b) Use some mathematical expression to generate wanted result c) Split multi-lefel IF() into several expressions, and add or concantenate results of those expressions d) Use CHOOSE function, to return up to 28 different pre-defined results. etc. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) |
IF FUNCTION
Hi Lando
Post a sample of wat you are trying to do. There may be other ways than IF functions. VLOOKUP perhaps. Regards Michael M "Lando" wrote: Why excel only allow us to create max 7 if fuction in one formula. How to manage if we want more .. Thanks guys |
All times are GMT +1. The time now is 08:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com