Forum Discussion
Assistance Needed in IF formula
I have two If statements that I need to merge together.
=IF (AND (C2 >499999, E2=3010), 3080, 3050,
=IF (AND (C2 >499999, E2=3020), 3090, 3060
3 Replies
Does this do what you want?
=E2+30*(C2>49999)+40
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.
So, initial formulae are not correct, we return 3090 if FALSE for both cases. And in both cases 3080 if TRUE, correct? If so
=IF( (C2>499999)*( (E2=3010)+(E2=3020) ), 3080, 3090 )
