if (text) then [value1, value2,,[

Colin Legg · #2 05-29-2011, 03:13 AM

Hi Andrew and welcome to the forum.

Quote:

Originally Posted by adj1

Sorry I tried to lay this out as a table, but the forum text editor didn't like it

You can always attach an example workbook to the thread?

If I understand correctly, you're saying that if column A is "Green" then column C should pick up the value from column B, but if column A is "Blue" then column D should pick up the value from column B?

In cell C1 put this formula:

Code:

=IF(A1="Green",B1,0)

In cell D1 put this formula:

Code:

=IF(A1="Blue",B1,0)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to find text in between two characters and then format selected text?	qcom	Word	5	02-19-2015 11:23 PM
Need help on Macro 03- Find text - if text is blank then remove line	simpleonline1234	Word VBA	1	02-25-2011 02:28 AM
Objective: Automatically export email text,attachment text to DB friendly format	SilentLee	Outlook	0	11-14-2010 02:45 PM
Templates: automatic text generation from Rich Text content control	Chickenmunga	Word	0	10-01-2008 11:16 AM
Cells with wrap text not showing text	lazylew	Excel	1	08-31-2008 06:58 AM