Forum Discussion
Excel Formula, combining two IF statement
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.
Value in E2 will always be either 3010 or 3020.
3 Replies
This is the third time (at least) that you ask the same question, and each time the descriptions are contradictory.
See Assistance Needed in IF formula | Microsoft Community Hub
As variant
=IF( E2=3010, IF( C2 >499999, 3080, 3050 ), IF( E2=3020, IF( C2 >499999, 3090, 3060 ), "wrong value in E2" ) )If Sergei's interpretation is correct and E2 will always be 3010 or 3020 then alternatively:
=E2+40 + (C2>49999)*30
