- Nov 30, 2005
- 1,059
- 1
- 81
Well, an Excel problem arises from my work and I believe there is a solution but I just don't know how.
Let's say 68001, 68002, 68003 are the sub-accounts of 68000, I want to be able to group them by the parent account (68000), I want my formula to do the following:
if(left(AccountNumber,5)=(68001, 68002, 68003),68000,0)
Well, that didn't work. I tried to put quote around each account number that still doesn't work. Any help?
Let's say 68001, 68002, 68003 are the sub-accounts of 68000, I want to be able to group them by the parent account (68000), I want my formula to do the following:
if(left(AccountNumber,5)=(68001, 68002, 68003),68000,0)
Well, that didn't work. I tried to put quote around each account number that still doesn't work. Any help?