I need a function called NEG.

[mach3]

i know about the ABS function, but i need a function that will make the value of a particular cell (e.g., cell A1) NEGATIVE or POSITIVE based on the condition of another cell (e.g., cell B1) regardless of whether the number in A1 is positive or negative.

sounds pretty easy, doesn't it? why isn't there a function called NEG or POS? or is there? what's the workaround? thanks.

mach3

 

[PaddyD]

Should be straightforward - how about posting the conditions you wnat to check..

Paddy

 

[kskinne]

you could still use the ABS function. =-ABS(A1) will take the absolute value of a cell A1, regardless of the sign to start with, and make it negative. this could be used in the context of an if statement in cell A1, for example:

=IF(B1<=10,-ABS(B1),ABS(B1))

would this work for you?

kevin

 

[ascalese]

You could try Dproduct

 

[NCay]

if(a1>1000,(a1*-1),"not true")
will return neg for cell if a1 is > 1000 ( insert your condition), otherwise will print "not true"