achavez507
New Member
- Joined
- Feb 7, 2020
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
Hello, i have successfully created two formulas to obtain the MV
First formula for Assets : =IFERROR(N(CUBEVALUE("121317",E20,F20,G20),0) The result gives me 10.
Second Formula for Liabilities: =IFERROR(N(CUBEVALUE("121317",E20,F20,G20,H20,I20,J20,K20),0) The result gives me 20.
I am having a hard time creating 1 formula for both. In cubevalue, it will try to look up H20, but its blank, which will result in error. If its blank, dont search for that h20.
Hope this helps!
First formula for Assets : =IFERROR(N(CUBEVALUE("121317",E20,F20,G20),0) The result gives me 10.
Second Formula for Liabilities: =IFERROR(N(CUBEVALUE("121317",E20,F20,G20,H20,I20,J20,K20),0) The result gives me 20.
I am having a hard time creating 1 formula for both. In cubevalue, it will try to look up H20, but its blank, which will result in error. If its blank, dont search for that h20.
Hope this helps!
A/L | Business (E20) | Product (f20) | SubProducts (G20) | Account H20 | Stable I20 | Core J20 | Size K20 | MV |
Assets | A | Overdrafts | Overdraft | 10 | ||||
Liabilities | C | Deposit | Cash | Account | Stable | Core | 0-25.000 | 20 |