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

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc