Formula Help - adding "x" to a value if true

[ksquared]

Hi,

I need help with a formula.

I need to modify cells in a colume depending on the cell value. If the cell contents is > or = to 75.00 or if it = 0.00, nothing needs to change. But if the cell contents is < 75.00 but > 0.00 I need to add 5.00 to the contents.

-------------------------------------------------

If the contents of a cell is > or = 75.00, do nothing (contents of C2 remains unchanged.)
But if the contents of cell C2 is < 75.00 but > 0.00, add 5.00 to the contents and store the new value in the cell.

Cell___Value before___Value afterwards
c2______75.00___________75.00
c3______50.00___________55.00
c4______0.00____________0.00

I hope that this is something someone can help me with and something an excell formula can do.

Thanks in advance.

K2

 

[T. Valko]

Hi,

I need help with a formula.

I need to modify cells in a colume depending on the cell value. If the cell contents is > or = to 75.00 or if it = 0.00, nothing needs to change. But if the cell contents is < 75.00 but > 0.00 I need to add 5.00 to the contents.

-------------------------------------------------

If the contents of a cell is > or = 75.00, do nothing (contents of C2 remains unchanged.)
But if the contents of cell C2 is < 75.00 but > 0.00, add 5.00 to the contents and store the new value in the cell.

Cell___Value before___Value afterwards
c2______75.00___________75.00
c3______50.00___________55.00
c4______0.00____________0.00

I hope that this is something someone can help me with and something an excell formula can do.

Thanks in advance.

K2

You would have to enter the formula in another cell, say cell D2.

Enter this formula in D2 and copy down as needed:

=C2+(AND(C2>0,C2<75)*5)

 

[ksquared]

Thank-you It worked perfectly. Much appreciated.

Cheers, K2

 

[T. Valko]

Thank-you It worked perfectly. Much appreciated.

Cheers, K2

You're welcome. Thanks for the feedback!