Posted to microsoft.public.excel.worksheet.functions

Christopher Naveen[_2_] Christopher Naveen[_2_] is offline

external usenet poster

Posts: 58

if condition

Hi,

I am trying with if condition but it returns some error. Pls refer the below
formula.

A B C D
ABC XYZ
DEF DEF

I am entering the formula in D1
=if(A1="ABC",B1="XYZ",A1)

Can anyone help me with the above formula.

Thanks in advance!

Chr.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
lookup with multiple condition, but one condition to satisfy is en	Eddy Stan	Excel Worksheet Functions	2	October 27th 07 02:06 PM
Combine an OR condition with an AND condition	Will	Excel Discussion (Misc queries)	1	April 6th 07 03:52 PM
Max or Min with condition	Marc	Excel Worksheet Functions	2	May 24th 06 10:08 PM
Condition Sum	Gos-C	Excel Worksheet Functions	3	February 17th 06 05:27 AM
Condition 1 overules condition 2?	Bultgren	Excel Worksheet Functions	2	January 20th 06 12:29 PM

All times are GMT +1. The time now is 05:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us