If/Then function

S

seansmrs3

I am not sure if I can get a function to do what I need, but I will try to
explain. I want to use an if/then function to perform a task of, if column f
<=0, then make the number in column D a negative (the number is already
populated in column D)...can this be done?

Thanks to anyone for their help
 
T

T. Valko

Is the value in column D manually entered? If so, you'll need to use another
cell:

F1 = some number
D1 = some number
E1 = formula:

=IF(AND(ISNUMBER(F1),F1<=0),D1*SIGN(-D1),D1)

If the number in column D is the result of a formula then you can
incorporate that formula with the one above. We'd need to see that formula
to make a specific suggestion.

Biff
 
Top