Multiply (C8-C4) by B10 to display positive only i.e. C8>=C4

Hi

=IF(C8>=C4,(C8-C4)*B10,"")
or
=ABS(C8-C4)*B10

depending on what you're acutally asking (its a good idea to write a bit in
the message body about what it is you're trying to achieve)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"seamusdoherty" <[email protected]> wrote in message
news:[email protected]...
>

LOL!

Gord

On Wed, 4 May 2005 08:05:29 -0700, "RagDyeR" <[email protected]> wrote:

>