G
Guest
I need to set 1 cell to meet certian conditions. ex. c16<=0, then e14=c16. If
c16>0, then e14=0
c16>0, then e14=0
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
You could use the case function or iif function.
Dr Alok Modi MD
Dr Alok Modi MD
G
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?
function, not just return a true or false value?
D
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.
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.
G
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
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