SUMIF Question

[gevelez]

Hola, esta es mi solución

=SI(SUMA($B9:B9)<$E$5,B9*$F$5,SI(SUMA(A9:$B9)<$E$5, (SUMA($B9:B9)-$E$5)*$G$5+($E$5-SUMA(A9:$B9)) *$F$5,B9*$G$5))

Mi versión de office esta en espanol, si se va a usar en una versíon en ingles hay que reemplazar suma por sum.

Gracias,

German Velez

[Title modified by Admin; Only MrExcel may submit Challenge of the Month Questions]

 

[ExcelChampion]

I came up with something very similar:-

=IF(SUM($B$9:B9)<$E$5,B9*$F$5,IF(SUM(A$9:$B9)>$E$5,B9*$G$5,(B9-MOD(SUM($B$9:B9),$E$5))*$F$5+(B9-(B9-MOD(SUM($B$9:B9),$E$5)))*$G$5))

...not as streamlined though...

 

[fairwinds]

Hi gevelez,

You should send your reply with E-mail as stated in the challenge.

Good luck! :wink:

 

[gevelez]

e-mail to send my answer

Hi gevelez,

You should send your reply with E-mail as stated in the challenge.

Good luck! :wink:

What is the e-mail to send mya answer?.

Thanks

Germán Vélez

 

[fairwinds]

Hi,

It was shown at the bottom of the challenge only he writes it as:

"bill at mrexcel.com"

I guess to avoid spam.

So replace the " at " with a @.

 

[Greg Truby]

German,

¿Ya, todo comprendido? El señor Jelen no se pone la arroba para evitar spam pero la dirección electrónica de él es Bill*MrExcel.com reemplazando el asterisco con la arroba.

Para la gente que desea ver el reto del mes, está aquí por el momento. En el futuro, cuando el reto mensual haya cambiado, estará listado en la página de retos del pasado.

Cordialmente,

 

[gevelez]

Muchas gracias.

Germán Vélez