help me write function?

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
> >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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >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.
> >>
> >>
> >>
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
> >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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >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.
> >>
> >>
> >>
>
>
>