I have an excel table which is pretty simple, but putting together code is
not one of my specialties. Each "record" is listed across a row, and each
column of that row is a characteristic. I need a function which lays out
like this: (things in quotes will be examples)

IF "D1=chicken" then "F1=cluck" or something to that extent. I tried using
Find and Replace, but it just gets too complicated the way i was trying it
before. Any help would be AWESOME.

in column F enter
=if(D1="chicken","Cluck", Otherwise)

"Zach" wrote:

I have an excel table which is pretty simple, but putting together code is
not one of my specialties. Each "record" is listed across a row, and each
column of that row is a characteristic. I need a function which lays out
like this: (things in quotes will be examples)

IF "D1=chicken" then "F1=cluck" or something to that extent. I tried using
Find and Replace, but it just gets too complicated the way i was trying it
before. Any help would be AWESOME.

Zach,

If cell F1, use a formula like

=IF(D1="Chicken","Cluck",IF(D1="Cow","Moo","Not a cow or chicken"))

I extended it because you wanted "something to that extent." <g

HTH,
Bernie
MS Excel MVP


"Zach" wrote in message
...
I have an excel table which is pretty simple, but putting together code is
not one of my specialties. Each "record" is listed across a row, and each
column of that row is a characteristic. I need a function which lays out
like this: (things in quotes will be examples)

IF "D1=chicken" then "F1=cluck" or something to that extent. I tried using
Find and Replace, but it just gets too complicated the way i was trying it
before. Any help would be AWESOME.

awesome, those are both great. is there any way to make it apply to the
whole column at once?

"Bernie Deitrick" wrote:

Zach,

If cell F1, use a formula like

=IF(D1="Chicken","Cluck",IF(D1="Cow","Moo","Not a cow or chicken"))

I extended it because you wanted "something to that extent." <g

HTH,
Bernie
MS Excel MVP


"Zach" wrote in message
...
I have an excel table which is pretty simple, but putting together code is
not one of my specialties. Each "record" is listed across a row, and each
column of that row is a characteristic. I need a function which lays out
like this: (things in quotes will be examples)

IF "D1=chicken" then "F1=cluck" or something to that extent. I tried using
Find and Replace, but it just gets too complicated the way i was trying it
before. Any help would be AWESOME.

Zach,

Copy it and paste it down your column to match your data. The D1 will change to D2, D3, etc.

HTH,
Bernie
MS Excel MVP


"Zach" wrote in message
...
awesome, those are both great. is there any way to make it apply to the
whole column at once?

"Bernie Deitrick" wrote:

Zach,

If cell F1, use a formula like

=IF(D1="Chicken","Cluck",IF(D1="Cow","Moo","Not a cow or chicken"))

I extended it because you wanted "something to that extent." <g

HTH,
Bernie
MS Excel MVP


"Zach" wrote in message
...
I have an excel table which is pretty simple, but putting together code is
not one of my specialties. Each "record" is listed across a row, and each
column of that row is a characteristic. I need a function which lays out
like this: (things in quotes will be examples)

IF "D1=chicken" then "F1=cluck" or something to that extent. I tried using
Find and Replace, but it just gets too complicated the way i was trying it
before. Any help would be AWESOME.

It's perfect, thanks to you both for helping me out. Smooth sailing from
here on out.

"Bernie Deitrick" wrote:

Zach,

Copy it and paste it down your column to match your data. The D1 will change to D2, D3, etc.

HTH,
Bernie
MS Excel MVP


"Zach" wrote in message
...
awesome, those are both great. is there any way to make it apply to the
whole column at once?

"Bernie Deitrick" wrote:

Zach,

If cell F1, use a formula like

=IF(D1="Chicken","Cluck",IF(D1="Cow","Moo","Not a cow or chicken"))

I extended it because you wanted "something to that extent." <g

HTH,
Bernie
MS Excel MVP


"Zach" wrote in message
...
I have an excel table which is pretty simple, but putting together code is
not one of my specialties. Each "record" is listed across a row, and each
column of that row is a characteristic. I need a function which lays out
like this: (things in quotes will be examples)

IF "D1=chicken" then "F1=cluck" or something to that extent. I tried using
Find and Replace, but it just gets too complicated the way i was trying it
before. Any help would be AWESOME.