need description if possible

[udprocks]

Good morning all,

Can anyone please help me with this formula , like what this formula does need a short description, Many thanks in advance.

=IF(O22<=0,"",VLOOKUP((IF(ISERR(AVERAGE(H16:H22)),0,ROUND((N22-N15)/N15,3))),SideNote,2,1))

 

[Hui]

If O22 <= 0 it will return a Blank
If O22 > 0 it will lookup a value in the first Column of table SideNote and return the value from the second column of the same table
The value it looks up will be either
0 if there is an error in H16:H22,
or
The value of (N22-N15)/N15 rounded to 3 decimal places

(N22-N15)/N15 sounds like it is calculating the difference between N22 and N15 as a decimal value which can be displayed as a Percentage

 

[Somendra Misra]

Hi Jitendra,

First of all there must be SideNote defined range in the workbook, having atleast 2 or more columns.

So, basically this function is triggering a VLOOKUP function only if value in the cell O22 is greater than 0, other wise the formula will return a null string.

Now in VLOOKUP, this part IF(ISERR(AVERAGE(H16:H22)),0,ROUND((N22-N15)/N15,3)) is giving the lookup value, so if there is an error in calculating average of the range H16:H22, the lookup value will be 0, otherwise it is equal to change in N22 from N15 (i.e. percentage change) rounded to 3 figures.

Now this value is looked up in the range SideNote and 2nd column is return for an approximate match as the fourth argument is 1.

Regards,

 

[udprocks]

Dear Hui & Somednra sir,

Thank you very much for your response and define for me this formula,

Really appericiate for your help and a brief and deep description of this formula..

Thanks again sir.