| Home > Forum Home > Analyzing Corporate Financial Data > Simple if > Use the AND function | Share |
Use the AND function
Excel Help for Use The And Function in Analyzing Corporate Financial Data
| Forum Topic | Login |
Use The And Function | Rate this: (3/5 from 1 vote) |
 | You can use the AND function to ensure all criteria are met: =IF(AND(A1=1,A2=2),"YES","NO") Although it looks like you need a conditional whereby any criteria is met, therefore you can do the same thing with an OR function. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
Excel templates and solutions matched for Use the AND function:Solutions: Technical Analysis Functions Download Exchange Rates Automate Macros Functions and Formulas QFD, FMEA and Pugh Templates |