Is there any way to add more than one true/false statement to one cell in excel?

I am creating a spreadsheet for a loan analysis, we need to be able to plug in a range of credit scores and their corresponding rate grade. I can only add one statement, and I cant figure out how to add more. Example =IF(C31%26lt;=530,';A';)Is there any way to add more than one true/false statement to one cell in excel?
Use the ';and'; function. You can put as many criteria as you want and they all have to be true in order to have the whole equation be true. If there are some options, use ';or';.Is there any way to add more than one true/false statement to one cell in excel?
Be more specific. Do you mean this =IF(C31%26lt;=530,';A';,';B';)


if C31 is less than or equal to 530 then A, if not B. Write out exactly what your wanting.