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
And quite often better to avoid IF(S) even if that's first what we have in mind - Detlef gave good examples. Alternative could be more compact, effective and maintainable. Assume if in IFS from previous post we have some complex expression instead of C7.
Hi there,
how to join together two =if(and( formulas in excel
Please
=if(and(H26>=50,H27>=50,H28>=50,H29>=50,H30>=50,H31>=50,H32>=50),"groß","")
=if(and(H26<50,H27<50,H28<50,H29<50,H30<50,H51<50,H52<50),"klein","")
how to join together two =if(and( formulas in excel
Please
=if(and(H26>=50,H27>=50,H28>=50,H29>=50,H30>=50,H31>=50,H32>=50),"groß","")
=if(and(H26<50,H27<50,H28<50,H29<50,H30<50,H51<50,H52<50),"klein","")
As variant
=IF( AND(H26>=50,H27>=50,H28>=50,H29>=50,H30>=50,H31>=50,H32>=50),"groß", IF( AND(H26<50,H27<50,H28<50,H29<50,H30<50,H51<50,H52<50), "klein", "" ) )or
=IF( AND( H26:H32 >=50 ),"groß", IF( AND( H26:H32 < 50 ),"klein", "" ) )- Thanks
