Formula Help Again
 

Sorry if anyone has seen my previous effort to explain this.

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. But if column B is empty I need the total to Be
Column A. Can anyone help please.

Formula Help Again
 

Hi
you have received several answers. What did not work for you?

"GBH99" wrote:

Sorry if anyone has seen my previous effort to explain this.

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. But if column B is empty I need the total to Be
Column A. Can anyone help please.

Formula Help Again
 

If column B is empty or at zero the total comes to zero and not to 30. Your
help so far has been invaluable though, thankyou.

"Frank Kabel" wrote:

Hi
you have received several answers. What did not work for you?

"GBH99" wrote:

Sorry if anyone has seen my previous effort to explain this.

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. But if column B is empty I need the total to Be
Column A. Can anyone help please.

Formula Help Again
 

Hi
try
=IF(B1="",A1,B1+A1*(A130))

"GBH99" wrote:

If column B is empty or at zero the total comes to zero and not to 30. Your
help so far has been invaluable though, thankyou.

"Frank Kabel" wrote:

Hi
you have received several answers. What did not work for you?

"GBH99" wrote:

Sorry if anyone has seen my previous effort to explain this.

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. But if column B is empty I need the total to Be
Column A. Can anyone help please.

Formula Help Again
 

Is it just

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Frank Kabel" wrote in message
...
Hi
you have received several answers. What did not work for you?

"GBH99" wrote:

Sorry if anyone has seen my previous effort to explain this.

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. But if column B is empty I need the total to Be
Column A. Can anyone help please.

Formula Help Again
 

=if(B1="",A1,if(A130,A1+B1,B1))

What if A1 and B1 are empty?


--
Regards,
Tom Ogilvy

"GBH99" wrote in message
...
Sorry if anyone has seen my previous effort to explain this.

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. But if column B is empty I need the total to Be
Column A. Can anyone help please.

Formula Help Again
 

For Empty or Zero


=if(or(B1="",B1=0),A1,if(A130,A1+B1,B1))

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
=if(B1="",A1,if(A130,A1+B1,B1))

What if A1 and B1 are empty?


--
Regards,
Tom Ogilvy

"GBH99" wrote in message
...
Sorry if anyone has seen my previous effort to explain this.

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. But if column B is empty I need the total to Be
Column A. Can anyone help please.