the anatomy of a nestled condition

  • Thread starter Thread starter farsta_online
  • Start date Start date
F

farsta_online

I ask if someone can discribe how to build a nestled condition in excel.
I know how a singel condition looks:
IF(c;b;d) there c = condition, b = if a is true, d = if a is false
But how about a nestled?
Let say I have 3 conditions c1 (b1, d1)
c2 (b2, d2)
c3 (b3, d3)

How should the formula in D3 look like?
And how should it look like a) if b = another condition?
b) if c = another condition?

And is there a easy way to know how condition 4,5, 6 shoud be added?

All help we´ll be appriciated
/Peter
 
=IF(A1>1000000,"Rich",IF(A1>10000,"OK",IF(A1>=0,"no debt","Bankrupt")))

You can only nest 7 conditions in one such thing.

HTH. Best wishes Harald
 
Back
Top