Hi everyone
this is my first participation, i need help in writing IF statment for the attached file as per the condition mentioned.
BR
Hi everyone
this is my first participation, i need help in writing IF statment for the attached file as per the condition mentioned.
BR
Generally a good idea to put the expected results into your sample so people can validate their logic.
Perhaps you mean:
B4:
=IF(B$1=A$1;"";(B$3-HLOOKUP(A$1;$A$1:B$3;3;0))/HLOOKUP(A$1;$A$1:B$2;2;0)%)
copied to P4
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks