More than 8 cond. in IF-formula

J

Jonsson

Hi ,

As I know it, excel doesnt manage more than 8 IF-statements.
Is it possible to do it some other way?

//Thoma
 
A

Andy B

Hi

Various other ways are possible. If you post what you've got, with sample
data, and what you want, I'm sure someone will oblige! The most likely
solution will be a lookup table.
 
F

Frank Kabel

Hi
in most cases using VLOOKUP and a lookup table can be used. But this
depends on your conditions
 
Top