View attached sample file where I need to adjust colum A formula to satisfy the listed conditions below:
If GL_Account id (col B) starts with 1 and 1 in QRM Contra (column F), then it is an Asset else
if GL_Account id (col B) starts with 1 and (-1) in QRM Contra (column F), then it is a Liability else
If GL_Account id (col B) starts with 2 and 1 in QRM Contra (column F), then it is an Liability else
If GL_Account id (col B) starts with 2 and (-1) in QRM Contra (column F), then it is an Asset else
If GL_Account id (col B) starts with 3 and 1 in QRM Contra (column F), then it is an Liability else
If GL_Account id (col B) starts with 3 and (-1) in QRM Contra (column F), then it is an Asset
Thanks in advance for help
Bookmarks