conditoonal programing
 

I am trying to enter a formula into excel that would dissplay the content of
one of the two cells unless the one of the cells contain a certin number the
* that number by a third cell.

ex if a1= "" then c1=b1 if not c1=a1 if b1="" then c1= a1 if b1=55 then
c1=b1*d1 if b1 is not blank but not 55 then c1=a1.

I have not been able to get it writen just right. I end up with only part
of the function working. I would like any help that anyone could offer. I an
using Excel 2002 with xp.
Thank you

conditoonal programing
 

I'm not clear on the requirements. It seems to me you have six possibilities
(a1 is blank or not blank; b1 is blank, =55, or neither). What should go in
C1 in each case?


"Brent" wrote:

I am trying to enter a formula into excel that would dissplay the content of
one of the two cells unless the one of the cells contain a certin number the
* that number by a third cell.

ex if a1= "" then c1=b1 if not c1=a1 if b1="" then c1= a1 if b1=55 then
c1=b1*d1 if b1 is not blank but not 55 then c1=a1.

I have not been able to get it writen just right. I end up with only part
of the function working. I would like any help that anyone could offer. I an
using Excel 2002 with xp.
Thank you

conditoonal programing
 

c1 is were the formula will be it will show the resualts and = eather the
value a1 or the value in b1 or if b1 = 55 it will =55*the value in d1

"bpeltzer" wrote:

I'm not clear on the requirements. It seems to me you have six possibilities
(a1 is blank or not blank; b1 is blank, =55, or neither). What should go in
C1 in each case?


"Brent" wrote:

I am trying to enter a formula into excel that would dissplay the content of
one of the two cells unless the one of the cells contain a certin number the
* that number by a third cell.

ex if a1= "" then c1=b1 if not c1=a1 if b1="" then c1= a1 if b1=55 then
c1=b1*d1 if b1 is not blank but not 55 then c1=a1.

I have not been able to get it writen just right. I end up with only part
of the function working. I would like any help that anyone could offer. I an
using Excel 2002 with xp.
Thank you

conditoonal programing
 

"bpeltzer" wrote:

I'm not clear on the requirements. It seems to me you have six possibilities
(a1 is blank or not blank; b1 is blank, =55, or neither). What should go in
C1 in each case?


"Brent" wrote:

I am trying to enter a formula into excel that would dissplay the content of
one of the two cells unless the one of the cells contain a certin number the
* that number by a third cell.

ex if a1= "" then c1=b1 if not c1=a1 if b1="" then c1= a1 if b1=55 then
c1=b1*d1 if b1 is not blank but not 55 then c1=a1.

I have not been able to get it writen just right. I end up with only part
of the function working. I would like any help that anyone could offer. I an
using Excel 2002 with xp.
Thank you

conditoonal programing
 

My interpretation is that if a1 isn't blank, return a1. If a1 is blank, then
if b1 is 55, return 55*d1, otherwise b1. That, in Excel:
=if(a1="",if(b1=55,55*d1,b1),a1).
Your first post makes an additional note about if b1=""; your follow-up and
the formula above don't address that. --Bruce


"Brent" wrote:

c1 is were the formula will be it will show the resualts and = eather the
value a1 or the value in b1 or if b1 = 55 it will =55*the value in d1

"bpeltzer" wrote:

I'm not clear on the requirements. It seems to me you have six possibilities
(a1 is blank or not blank; b1 is blank, =55, or neither). What should go in
C1 in each case?


"Brent" wrote:

I am trying to enter a formula into excel that would dissplay the content of
one of the two cells unless the one of the cells contain a certin number the
* that number by a third cell.

ex if a1= "" then c1=b1 if not c1=a1 if b1="" then c1= a1 if b1=55 then
c1=b1*d1 if b1 is not blank but not 55 then c1=a1.

I have not been able to get it writen just right. I end up with only part
of the function working. I would like any help that anyone could offer. I an
using Excel 2002 with xp.
Thank you

conditoonal programing
 

that worked great thank you very much Brent

"bpeltzer" wrote:

My interpretation is that if a1 isn't blank, return a1. If a1 is blank, then
if b1 is 55, return 55*d1, otherwise b1. That, in Excel:
=if(a1="",if(b1=55,55*d1,b1),a1).
Your first post makes an additional note about if b1=""; your follow-up and
the formula above don't address that. --Bruce


"Brent" wrote:

c1 is were the formula will be it will show the resualts and = eather the
value a1 or the value in b1 or if b1 = 55 it will =55*the value in d1

"bpeltzer" wrote:

I'm not clear on the requirements. It seems to me you have six possibilities
(a1 is blank or not blank; b1 is blank, =55, or neither). What should go in
C1 in each case?


"Brent" wrote:

I am trying to enter a formula into excel that would dissplay the content of
one of the two cells unless the one of the cells contain a certin number the
* that number by a third cell.

ex if a1= "" then c1=b1 if not c1=a1 if b1="" then c1= a1 if b1=55 then
c1=b1*d1 if b1 is not blank but not 55 then c1=a1.

I have not been able to get it writen just right. I end up with only part
of the function working. I would like any help that anyone could offer. I an
using Excel 2002 with xp.
Thank you