And the difference would be?

Don't get me wrong I'm all for streamlining formulae, but when
you are just talking about two ways around a square. Why bother?

Regards
Martin


"Ron Coderre" wrote in message
...
If Martin interpreted your post correctly,
try this:

=SUM(SUMIF(B2:B33,"0")*0.5,B2:B33)

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Ron Coderre" wrote in message
...
Try this:

=SUMIF(B2:B33,"0")*1,5

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Gutti" wrote in message
...
I have numbers 0 and <0 in a column B2 to B33. I have to multiply the
numbers 0 with 1,5 and add the column. Please help.
Gutti