If/Then function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent functions from changing when new rows are added 1
If, then 5
CONDITIONAL FORMATTING & NEGATIVE VALUES 1
Change positive number to negative number 1
IF Function and Concatenation 8
If then request 1
Formula appears, but its function is not performed????? 1
making a # value positive or negative based on contents of another 3

Back
Top