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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Multiply (C8-C4) by B10 to display positive only i.e. C8>=C4 (https://www.excelbanter.com/new-users-excel/24804-multiply-c8-c4-b10-display-positive-only-i-e-c8%3E%3Dc4.html)

seamusdoherty

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

JulieD

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" wrote in message
...

RagDyeR

Gord Dibben

LOL!

Gord

On Wed, 4 May 2005 08:05:29 -0700, "RagDyeR" wrote:

All times are GMT +1. The time now is 07:47 PM.