Formula

[Guest]

If column A is 30 and column B is 50, I need a formula that will only print
the 50, but if column A is any figure abouve 30 I need the formula to add
column A + B together. Can anyone help please.

 

[Wayne Morgan]

Are you doing this in an Access Report? If so, create a textbox on the
report and set its Control Source to an equation.

=IIf([A]<=30, , [A]+)

You said columns, not fields. If these are column in a listbox, let me know.
If they are fields, the above should work. If you are talking Excel, then
please try an Excel newsgroup.

 

[Guest]

are we talking about access or excel?

 

[Joseph Meehan]

If column A is 30 and column B is 50, I need a formula that will only
print the 50, but if column A is any figure abouve 30 I need the
formula to add column A + B together. Can anyone help please.

If this is an MS Access database question, your question is flawed. If
TABLE A is 30 characters wide then you would never have more than 30
characters. It sounds like you are talking about MS Excel, the spreadsheet
program. This is the Microsoft Access Database newsgroup. It appears your
question is not related to that database. You are much more likely to find
someone with the answer if you post your question to a newsgroup devoted to
your subject.