On Sat, 22 Oct 2005 15:25:02 -0700, "Alex"
wrote:

I need to test a cell value to determine if is negative or positive. If
negative, the value gets subtracted from partA and added to partB. If
positive, it gets added to partA and subtracted from partB. I've seen a few
posts close to this problem, but not close enough to help me. I'm stumped,
my "if" statements keep running me in circles. I've got plenty of room
offscreen to do this evaluation, but ... .

Thanks!


If(yourcell<0,partB+partA-yourcell,PartB-partA+yourcell)

HTH, if not a specific example would be useful.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________