Formulas
 

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.

Formulas
 

try this:

=IF(A130, A1+B1, B1)

cheers
big t


"GBH99" wrote:

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.

Formulas
 

Hi
=B1+A1*(A130)

"GBH99" wrote:

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.

Formulas
 

=if(A130,A1+B1,B1)
--
Regards,
Tom Ogilvy

"GBH99" wrote in message
...
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.

Formulas
 

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

"Tom Ogilvy" wrote:

=if(A130,A1+B1,B1)
--
Regards,
Tom Ogilvy

"GBH99" wrote in message
...
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.