| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditions
Hello,
Thanks in advance for the help. I want to return the word "TRUE" in column G2 if column A2 shows "SF" and Column I2 is blank. If column A shows anything other than "SF" it will not meat the condition and G2 should remain blank. If I2 shows any data, then G2 should remian blank. Again, thanks for the help. Jim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditions
=IF(AND(A2="SF",I2=""),TRUE,"")
-- __________________________________ HTH Bob "Jim" wrote in message ... Hello, Thanks in advance for the help. I want to return the word "TRUE" in column G2 if column A2 shows "SF" and Column I2 is blank. If column A shows anything other than "SF" it will not meat the condition and G2 should remain blank. If I2 shows any data, then G2 should remian blank. Again, thanks for the help. Jim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditions
Use this formula.
=IF(AND((A2="SF"),(I2="")),"TRUE","") If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Jim" wrote: Hello, Thanks in advance for the help. I want to return the word "TRUE" in column G2 if column A2 shows "SF" and Column I2 is blank. If column A shows anything other than "SF" it will not meat the condition and G2 should remain blank. If I2 shows any data, then G2 should remian blank. Again, thanks for the help. Jim |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditions
Yes, but you don't need so many parentheses.
You can change =IF(AND((A2="SF"),(I2="")),"TRUE","") to =IF(AND(A2="SF",I2=""),"TRUE","") And are you sure that the OP wanted the text string "TRUE"? If Jim wanted the boolean value TRUE, throw away the quote marks round it, and make it =IF(AND(A2="SF",I2=""),TRUE,"") -- David Biddulph "Ms-Exl-Learner" wrote in message ... Use this formula. =IF(AND((A2="SF"),(I2="")),"TRUE","") If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Jim" wrote: Hello, Thanks in advance for the help. I want to return the word "TRUE" in column G2 if column A2 shows "SF" and Column I2 is blank. If column A shows anything other than "SF" it will not meat the condition and G2 should remain blank. If I2 shows any data, then G2 should remian blank. Again, thanks for the help. Jim |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditions
David Sir,
I am getting lot of valuable informations from you... -------------------- (Ms-Exl-Learner) -------------------- "David Biddulph" wrote: Yes, but you don't need so many parentheses. You can change =IF(AND((A2="SF"),(I2="")),"TRUE","") to =IF(AND(A2="SF",I2=""),"TRUE","") And are you sure that the OP wanted the text string "TRUE"? If Jim wanted the boolean value TRUE, throw away the quote marks round it, and make it =IF(AND(A2="SF",I2=""),TRUE,"") -- David Biddulph "Ms-Exl-Learner" wrote in message ... Use this formula. =IF(AND((A2="SF"),(I2="")),"TRUE","") If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Jim" wrote: Hello, Thanks in advance for the help. I want to return the word "TRUE" in column G2 if column A2 shows "SF" and Column I2 is blank. If column A shows anything other than "SF" it will not meat the condition and G2 should remain blank. If I2 shows any data, then G2 should remian blank. Again, thanks for the help. Jim . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| 2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| Conditions Help | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Linear Mode
