Bug 155755 - FUNCTION: suggestion for MULTIPLY.IF()
Summary: FUNCTION: suggestion for MULTIPLY.IF()
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-06-09 12:53 UTC by Michel COLLET
Modified: 2023-06-10 16:54 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Michel COLLET 2023-06-09 12:53:59 UTC
I suggest the new function MUTIPLY.IF()
identical to SUM.IF() with a multiplication instead of an addition, and with the same parameters
Comment 1 Michel COLLET 2023-06-09 13:14:39 UTC
an improvement could be in the specification of a multiplier area and a multiplicand area.
The multiplier area and the multiplicand area must have:
  the same size,
  either be in column or in line,
  or one could be in column and the other in line and vice versa.
Each cell in the multiplier area have to be multiplied by the corresponding cell in the multiplicand area.
Corresponding cells are: first cell of the multiplier area with the first cell of the multiplicand area, second one with the second one, etc
Comment 2 Eike Rathke 2023-06-09 14:10:59 UTC
That wouldn't deliver a single return value though like SUMIF() (note it's not SUM.IF() that was probably because in French it's SOMME.SI()) but an array/matrix and that can already be accomplished by entering
=range1*range2*condition
as array formula, i.e. closing it with Shift+Ctrl+Enter instead of Enter.
Example: =A1:A5*B1:B5*(C1:C5<>23)
multiplies cells of A1:B5 with cells of B1:B5 if the corresponding value in C1:C5 does not equal 23; returns an array of 5 values, 0 if condition is not met.

If in comment 0 you meant to multiply all values of a range for a condition, that can be accomplished similar using
=PRODUCT(IF(C1:C5<>23;A1:A5;""))
as array formula (French PRODUIT()).
Comment 3 Michel COLLET 2023-06-09 14:20:58 UTC
@ Eike Rathke
waouh, so great!
I don't have this description in my french documentation. Thanks a lot Eike
Comment 4 danomois 2023-06-10 16:54:49 UTC
Considering the final response copied below, I believe this is resolved. Possibly an opportunity for French version documentation enhancement.

Also it does not appear to be a bug submission but an enhancement request.

@ Eike Rathke
waouh, so great!
I don't have this description in my french documentation. Thanks a lot Eike