On 16 Jun., 21:51, GS wrote:
wiasta explained :

hi,
can you let me know please, how deep (how many level) this function is
nested?
=IF(B51F51;CONCATENATE("";D51);IF(B51<F46;CONCAT ENATE("<";D46);
(10^(FORECAST(B51;OFFSET(E45;D52-1;;2);OFFSET(F45;D52-1;;2))))))

The nesting shouldn't be more than double, otherwise I have to
validate my excel spreadsheet at work before using it.

thanks
Sar

First thing I see here is that you are using ";" to separate your args,
which doesn't work. Use a comma.

You can safely 'nest' up to 7 IF() functions without any problems (in
most cases). If you need more than that then you'll have to put Defined
names to use so it handles a greater number of IFs for you. For
example, you could put your last FALSE condition in a named formula:

* In the namebox:
* * 'Sheet Name'!BuildForecast

* In the RefersTo box:
* * =10^(FORECAST(B51;OFFSET(E45;D52-1;;2);OFFSET(F45;D52-1;;2)))

You could also do similar with your CONCATENATE() conditions:

* In the namebox:
* * 'Sheet Name'!MakeGreaterThan

* In the RefersTo box:
* * =CONCATENATE("", D51)
</

* In the namebox:
* * 'Sheet Name'!MakeLessThan

* In the RefersTo box:
* * =CONCATENATE("<", D46)

The resulting formula:
* =IF(B51F51,MakeGreaterThan,IF(B51<F46,MakeLessTha n,BuildForecast))

HTH

thank you, but I still do not know how many this function is nested!
Is that more than double neting?
=IF(B51F51;CONCATENATE("";D51);IF(B51<F46;CONCAT ENATE("<";D46);
(10^(FORECAST(B51;OFFSET(E45;D52-1;;2);OFFSET(F45;D52-1;;2))))))