On Aug 9, 5:48 am, Excel beginner
wrote:
Awesome, thanks! Would I do the same for a nested IF function?

=IF(AND(P3<=Q3,P3T3),"value if true",IF(AND(P3<=R3,P3Q3,
"value if true",etc.

You could; but in Excel 2003 and earlier, there is a limit of 7 nested
function calls (8, if you count the outer-most function).

If "value if true" is the same value for both conditions, you could do
something like:

=if(or(and(P3<=Q3,P3T3), and(P3<=R3,P3Q3)), "value if true", "value
if false")