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
=IF(C7<=69,SUM(C7*0.65),IF(C7>=70,SUM(C7*0.5)))
=IF(C7<=69,SUM(C7*0.65),IF(C7>=70,SUM(C7*0.5)))
