Non of the formulas I use gets converted..
Here is some examples:
ISNUMBER
SUMIF
IF
AVERAGE
SUMPRODUCT
i.e.
=SUMPRODUCT(--(Inntekter!$B$5:$B$203=$B197),
--(TEXT(Inntekter!$A$5:$A$203,"yyyymm")=""&K$9&""),
--(Inntekter!$C$5:$C$203=$B$193),
(Inntekter!$E$5:$E$203))
--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread:
http://www.excelforum.com/showthread...hreadid=514363