| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
