Formula

G

GBH99

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.
 
W

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.
 
Top