G'day there Peepuls,

[This followup was posted to microsoft.public.excel.programming and a
copy was sent to the cited author.]

in B1: =IF(C1<0;A1;'value you want in b1')

I think that should be "=IF(C1<0, A1, 'value you want it b1')".
Commas, not semi-colons. (Paul I think you typed too fast <g)

See ya
Ken McLennan
Qld, Australia