IF function

[MattVarnell]

I am trying to use the IF function to make a cell display one of two text strings. I have cells L3 L4 & L5 tagged as Credit and P3 through P8 tagged as Debit. In cell A10 the Data Validation is "List" using the above cells as the source. What I want to do, is when I choose from the drop down list in cell A10, I want Cell D10 to display either "Income" or "Expense". A credit will be income, while a debit will be expense. I can make this work using only half of the formula, but I can't seem to combine two IF formulas. Here is the formula that works: =IF(A10="Credit","","Income"). Should I be using another funtion other than IF?

Thank you in advance for your help!

[martindwilson]

since you only have 2 options why not =IF(A10="Credit","Income","expense").
if blank is also an option then
if(a10="","",IF(A10="Credit","Income","expense"))

[jrdnoland]

The IF statement Format: Result=IF(test,Then,Else)

So, with this in mind you can replace the "Else" part with a new "IF" up to seven times.

IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))

Please Login or Register  to view this content.

[MattVarnell]

I have tried that formula, and just to make sure I tried it again. No matter what you choose in A10, the result in D10 refers to the "value_if_false" text, which in this case is "Expense". If you reverse the true and false values, it always reverts to the false value.

[martindwilson]

make sure the dropdown text is exactly the same as the text in formula
check =length(a10) =6 for credit there may be a space at the end
or try
=IF(TRIM(A10)="Credit","Income","expense")

[MattVarnell]

The IF statement Format: Result=IF(test,Then,Else)

So, with this in mind you can replace the "Else" part with a new "IF" up to seven times.

IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))

Please Login or Register  to view this content.

I tried this, but the cell remains blank. Let me try to be more specific. In cells L4 and L5 I have AD and D respectively. These two cells are taggedas credit. In cells P4 through P8 I have AP, ATM, DC, FT, and SC tagged as Debit. When I click on cell A10 a list drops down displaying all of the above codes. If I were to choose either AD or D I want cell D10 to display Credit, and if I choose AP, ATM, DC, FT, or SC I want cell D10 to display Debit.

[martindwilson]

=IF(OR(A10={"ad","d"}),"credit","debit")

[jrdnoland]

Matt - I would follow what Martin is suggesting, my only other input would be that you need to also be aware of case sensitivity.

If you still can't get it to work, you can attach the worksheet.

[teylyn]

case sensitivity.

in simple conditions like this, Excel ignores case

="Hello World"="hELLO wORLD"

evaluates to TRUE.

AFAIK, only FIND(), EXACT() and the arguments for CONVERT() are case sensitive.

[MattVarnell]

That Did It!!! Thank You Guys so much for your help!!!