:-)
thanks J.E
missed that bracket

--
Regards
Frank Kabel
Frankfurt, Germany
"JE McGimpsey" schrieb im Newsbeitrag
...
Note that the porposed substitute is a million times too small <g.
Perhaps

=IF(K11="","",K11/AB12*1000)

In article ,
"Frank Kabel" wrote:

first you could simplify your existing formulas a little bit :-)
=IF((K11)="","",SUM((K11)/(AB12))*1000)
becomes
=IF(K11="","",K11/(AB12*1000))