Help with simple formula

[deletedalien]

Hi there just a quick question...

Why isn't this formula working???

=IF(IF(B3="Student Loans",1,2)=IF(G3="Student Loans",1,2),"ok","Check Campaign")

It should check if BOTH B3 and G3 say Student loans and if they BOTH say that then it should redutn ok otherwise check campaign,

which it does.... BUT

if i type any other 2 equal values on B3 and G3 it still returns ok....

and i need for it to make sure that it specifically read student loans there.

Any help is appreciated.

Thanx in advance.

 

[SlamDunk]

Try this formula, it will do what you are trying to achieve.

=IF(AND(B3="Student Loans",G3="Student Loans"),"ok","Check Campaign")

 

[deletedalien]

Superb!

 

[deletedalien]

could this be possible with 4 non contiguous ranges?

 

[SlamDunk]

Unfortunately my imagination is poor and I don't understand your question

 

[deletedalien]

Sorry

It just came to my attention that a different part of my report requires me to check 4 different cells to make sure they all match Specifically B2, D2, G2, I2

 

[My Aswer Is This]

Yes this would work:
=IF(AND(B3="Student Loans",G3="Student Loans",B21="Student Loans",G12="Student Loans"),"Ok","Check Campaign")

 

[deletedalien]

Simply Brilliant.....



Thank you VERY much!