Setting a cell to react to certian conditions

G

Guest

I need to set 1 cell to meet certian conditions. ex. c16<=0, then e14=c16. If
c16>0, then e14=0
I have tried using "if". When I do, the only results I get are either true
or false.
I need the cell (e14) to actually perform the function stated above.
 
G

Guest

=IF(C16<=0,C16,0)

this will return zero if the cell value is more than 0
if you do not want zero ( but a blank cell, replace the last zero with ""
 

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

Setting a cell to react to certian conditions 4
Text box does not populate linked cell 2
Formula??? 3
Conditional Formatting - comparison with another cell 4
Changing up to 2 of 3 vals and the 3rd val is automatically Calcul 4
Help with solving this if statement which uses a search for text s 9
conditional format question 4
Excel VBA 1

Top