deletedalien
Well-known Member
- Joined
- Dec 8, 2008
- Messages
- 505
- Office Version
- 2013
- Platform
- Windows
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.
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.