Hello, please can someone helps me to understand this formula: =SI(D4=Lists!$I$2;"1.0";SI($D4="";"";MOYENNE(RECHERCHEV($D4;Lists!$I$1:$Q$6;9;0);(RECHERCHEV($E4;Lists!$J$1:$Q$6;8;0)))))
Please see attached
Posted 29 July 2021 - 01:00 PM
Hello, please can someone helps me to understand this formula: =SI(D4=Lists!$I$2;"1.0";SI($D4="";"";MOYENNE(RECHERCHEV($D4;Lists!$I$1:$Q$6;9;0);(RECHERCHEV($E4;Lists!$J$1:$Q$6;8;0)))))
Please see attached
Posted 29 July 2021 - 03:02 PM
I don't see an attachment. It looks like its in French.
=IF(D4=Lists!$I$2;"1.0";IF($D4="";"";AVERAGE(VLOOKUP($D4;Lists!$I$1:$Q$6;9;0);(VLOOKUP($E4;Lists!$J$1:$Q$6;8;0)))))
Above is translated. Lemme try to interpret it. I assume french syntax is the same as english.
---
If D4 is I2, then its 1 (not sure why this is a text string)
if D4 is NOT I2, then proceed
if D4 is blank, this cell is blank (typically used to prevent ugly errors in cells)
if D4 is NOT blank, then proceed
We need an average of two values, and to do that we need to look them up
First lookup
find D4 in the range I1:Q9, then return the result in column 9 in that row
Second lookup
Find E4 in the range J1:Q6, then return the result in column 9 in that row
Once those two lookups are returned, it takes an average of those values
---
So basically, If D4 is I2, then its one, if its not and its blank then its blank, if its not blank, and its not I2, then find two numbers in the same row as D4 in another table and average them together.
That's the best I can do not having seen the spreadsheet.
Edited by johnmcip, 29 July 2021 - 03:15 PM.
0 members, 0 guests, 0 anonymous users