Thread: Conditions
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ms-Exl-Learner Ms-Exl-Learner is offline
external usenet poster
 
Posts: 506
Default 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