Posted to microsoft.public.excel.worksheet.functions
|
|
mulitple formulas
Sorry to be a pest. I am putting this IF statment in cell C105. I want it to
go off whatever is in C3, either "C" or "d". I want the result to be in C105.
thanks again.
"BekkiM" wrote:
Don't retype it--just copy and paste the entire formula (including the "=")
in D3 (then copy it down for other rows).
If you're trying to type/paste it into C3, it won't work--you'll get a
circular reference (and, if you're doing that, I suspect you're looking for
data validation, not a formula)
"charlie" wrote:
I retyped this about 10 times and cannot seem to get it to work. Also, my
choice are going to be "d" or "c". Thanks for the headsup.
"BekkiM" wrote:
=IF(C3="d","District,IF(C3="c","County Courts at Law",""))
You can do it with one IF statement, but ONLY if your only two choices are
"c" and "d"--if there's anything else in column C (even blanks), you'll get
incorrect labels in your name column. For example:
=IF(C3="d","District","County Courts at Law") gives you:
IF C3 = "d", D3 = "District"
IF C3 = "c", D3 = "County Courts at Law"
IF C3 = "M", D3 = "County Courts at Law"
"charlie" wrote:
I need help with a multiple formula in the same cell. I will write it like it
should go.
if C3=d then = District
if C3=c then = County Courts at Law
I am trying to put these in the same cell.
Please email with answer,
thanks very much,
cp
|