Hello, I am having probles with IF statements. Can someone please help me. I am really confused on this. Thanks
=IF(and(AN3>=TODAY(),BD3>=0),"Open","Closed") & IF(and(AN3>=TODAY(),BD3>=1),"Funds remain","Research"))))
Hello, I am having probles with IF statements. Can someone please help me. I am really confused on this. Thanks
=IF(and(AN3>=TODAY(),BD3>=0),"Open","Closed") & IF(and(AN3>=TODAY(),BD3>=1),"Funds remain","Research"))))
You need to nest the functions.
However, I can't quite tell how you would put those two IF statements togethe since they both output different results.
Update your question with a sample file showing the result that you would like to get and I can better help you.
I think one of these IF statements might be what you are looking for:
=IF(AN3>=TODAY(),"Open",IF(OR(BD3>=1,AND(BD3<1,BD3>=0)),"Closed & Funds remain","Closed & Research"))
or
=IF(AN3>=TODAY(),"Open",IF(BD3>0,"Closed & Funds remain","Closed & Research"))