Mick,
I'm inclined to write that formula as follows...

=IF(LEN(I39),(I39*I40)+I39,"")
OR
=IF(NOT(I39),"",SUM(I39*I40,I39))

...for better clarity as opposed to checking I39<"" -OR- I39="",
respectively.<g

--
Garry

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