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
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
)
