IF function questions

  • Thread starter Thread starter Jo Anna Sims
  • Start date Start date
J

Jo Anna Sims

How do I make a function where I want the following
information.

If a certain column contains a value less than or equal to
zero then I want the information in another column to be
zero but if the information is not less than or equal to
zero then I want the value that is entered in this other
particular column to stay the same.
 
Jo Anna Sims said:
How do I make a function where I want the following
information.

If a certain column contains a value less than or equal to
zero then I want the information in another column to be
zero but if the information is not less than or equal to
zero then I want the value that is entered in this other
particular column to stay the same.
Click to expand...

It's easier if you give example column letters. Also, as you will write a
formula in the first row and copy it down the column, all you need to ask
for is the formula for the first row.

Now, you must understand that you cannot have both a data value and a
formula in the same cell; you must use two separate cells.

Let's say that:
A1 contains the value that might be less than or equal to zero.
B1contains the value that you enter.
Then in C1 you can put the formula
=IF(A1<=0,0,B1)
 
Jo Anna
A function/formula in a cell can effect the displayed value in that cell
only. It cannot effect the value of another cell. You will have to use
some other cells or do it with VBA. HTH Otto
 
Back
Top