Hi,

In the formula below the AND function cannot recognise the named range
"KolomFFundering". I need the named range because when I insert a row
the range must also change. Is there any way to rewrite this formula
without losing it's function? The range of "KolomFFundering" is
F13:F23.

=IF(AND(J12<"";KolomFFundering<"");"verwijder getal uit kolom
'hoeveelheid'";IF(KolomFFundering<"";SUM(KolomFFu ndering);IF(P12<"";P12/L$227;"")))

Thanks in advance!


--
leonidas
------------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=554633