formula problem

I'm not exactly new to spreadsheets - started with VisiCalc - but
haven't used them much in years. The only one I have now is the one
in an old MSWorks (version 4.5a) and I'm having a problem getting a
formula I need.

Let's call one cell "Old", another "New" and the formula cell
"Result". In Basic, I'd write it sort of like this...

IF Old > New THEN Result = (Old - New) * -1
ELSE IF New = 0 THEN Result = 0
ELSE Result = New - Old

Could someone please tell me how to translate that to a formula for my
spread*** program?

--

dadiOH
____________________________

dadiOH's dandies v3.06...
....a help file of info about MP3s, recording from
LP/cassette and tips & tricks on this and that.
Get it at http://mysite.verizon.net/xico


.