Setting a cell to react to certian conditions

[Guest]

I need to set 1 cell to meet certian conditions. ex. c16<=0, then e14=c16. If
c16>0, then e14=0

 

[Guest]

You could use the case function or iif function.

Dr Alok Modi MD

 

[Guest]

I tried usung"if", but how do I get the the cell c14 to actually perform the
function, not just return a true or false value?

 

[Douglas J. Steele]

Sounds as though you're talking about Excel, in which case you should post
your question to a newsgroup that deals with Excel.

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

 

[Guest]

Hi Rob
It sound like an Excel question, this is Microsoft Access discussion group,
and in access we refer to cell as fields and records.

In Access your answer will be
e14 = iif( c16<=0, c16, 0)

But if it is Excel question, you can try Microsoft excel discussion group