help me write function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
awesome, those are both great. is there any way to make it apply to the
whole column at once?
 
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
 
It's perfect, thanks to you both for helping me out. Smooth sailing from
here on out.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AND function 6
Sum with matrix functions? 8
function help! 6
Help me write a function please? 10
will a function do this for me? 1
Lookup function in Excel 6
Excel formula / IF function 5
how to use the ceiling function 2

Back
Top