Penny,

Would =IF(AND(A1<0,B1<0),-(A1*B1),A1*B1) do what you want? With the data I
get -18.6576 with the formula.

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Penny" wrote in message
...
I want to mulitply 2 #
# may or may not be negative
if it is negative the answer should show that eg:

a=-33.04*b=-1.69

What is the formula????

at the moment the result shows up as a positive 11.83

Help