Setting a cell to react to certian conditions

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
=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 ""
 
Back
Top