Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programing Help Needed | Excel Programming | |||
this is about excel programing | Excel Programming | |||
Proper Programing | Excel Programming | |||
VB programing | Excel Programming | |||
Help with VBA programing | Excel Programming |