Forum Discussion
Excel Formula, combining two IF statements
I need to string together two IF statements, =IF(C7>=70, C7*0.5) and =IF(C7<=69, C7*0.65), please help
Hello,
I need to combine 2 if statements:
=IF (AND (C2 >499999, E2=3010), 3080, 3050,
=IF (AND (C2 >499999, E2=3020), 3090, 3060
I want to create a Formula to check if value in cell C2 is greater than 499999. If it is, then checks if the value in cell E2 is 3010; if true, it returns 3080, otherwise it returns 3090.
Formula also checks if value in cell C2 is greater than 499999, and value value in cell E2 is 3010; if true, it returns 3080, otherwise it returns 3090.
ROSAMEJIA , it's better to continue this discussion in separate thread with the same your question Assistance Needed in IF formula | Microsoft Community Hub