Formulas

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

 

[Guest]

try this:

=IF(A1>30, A1+B1, B1)

cheers
big t

 

[Guest]

Hi
=B1+A1*(A1>30)

 

[Tom Ogilvy]

=if(A1>30,A1+B1,B1)

 

[Guest]

=sum(a1:b1) and then copy and paste. Copy and paste it .the best orthodox way.