Forum Discussion

ROSAMEJIA's avatar
ROSAMEJIA
Copper Contributor
May 06, 2025

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...
admin
community
excel
Formulas and Functions
office 365
training
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 06, 2025

As variant

=IF( E2=3010, IF( C2 >499999, 3080, 3050 ),
 IF( E2=3020, IF( C2 >499999, 3090, 3060 ),
 "wrong value in E2" ) )

 

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    May 06, 2025

    If Sergei's interpretation is correct and E2 will always be 3010 or 3020 then alternatively:

    =E2+40 + (C2>49999)*30

Resources