Forum Discussion
Excel Formula, combining two IF statements
The two if statements you think you need are really just one:
Here's an outline of a basic IF
=
IF(
logical test,
perform this IF TRUE,
perform this IF FALSE
)
Here's your initial restated:
=
IF(
C7>=70,
C7*0.05,
C7*0.65
)
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
