Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default check value in cell

hello all,

if in cell a1 is (cat) then in cell B1 should be (miau), if the a1 (dog) then b1 (wow), and if a1 (cow) then the b2 (mu)

Thank you in advance for your help
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default check value in cell

Hi Marin,

Am Fri, 22 Feb 2013 10:39:41 -0800 (PST) schrieb Marin:

if in cell a1 is (cat) then in cell B1 should be (miau), if the a1 (dog) then b1 (wow), and if a1 (cow) then the b2 (mu)


try:
=VLOOKUP(A1;{"cat"."miau";"dog"."wow";"cow"."mu"}; 2;0)
or:
=IF(A1="cat";"miau";IF(A1="dog";"wow";IF(A1="cow"; "mu";"")))

and change the delimiter if the formulas don't work for your language


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default check value in cell

On Friday, February 22, 2013 7:50:42 PM UTC+1, Claus Busch wrote:
Hi Marin,



Am Fri, 22 Feb 2013 10:39:41 -0800 (PST) schrieb Marin:



if in cell a1 is (cat) then in cell B1 should be (miau), if the a1 (dog) then b1 (wow), and if a1 (cow) then the b2 (mu)




try:

=VLOOKUP(A1;{"cat"."miau";"dog"."wow";"cow"."mu"}; 2;0)

or:

=IF(A1="cat";"miau";IF(A1="dog";"wow";IF(A1="cow"; "mu";"")))



and change the delimiter if the formulas don't work for your language





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2



thank you very much Claus
IF command works perfectly
thanks again, you have helped me a lot;)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
check or uncheck a check box based on a cell value RTKCPA Excel Discussion (Misc queries) 1 February 3rd 10 04:11 PM
Copy and move check box (check boxes) with new cell link? Marty Excel Worksheet Functions 1 January 20th 10 08:43 PM
Cannot check the check mark box in cell ac Excel Worksheet Functions 1 February 15th 08 11:24 PM
check to see if a cell is blank if not populate adjacent cell wit. Frusterated Excel Discussion (Misc queries) 6 September 14th 07 10:55 PM
Check if Conditional Format is True or False / Check cell Color Kevin McCartney Excel Worksheet Functions 5 June 29th 07 11:12 AM


All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"