Adding range of account [SOLVED]

Questions and Answers asked by users to users, about how others use Jet Express.

Adding range of account [SOLVED]

Postby pblais » Tue Nov 22, 2016 7:39 am

Hi, I'm pretty new with the Product. I would like to know how could I enter on a line for example account 000-1000-00 through 000-1500-00 minus account 000-1200-00? Is there a way to do this efficiently with Jet Express for Excel with GP?

Thanks
Pat
pblais
 
Posts: 2
Joined: Tue Nov 22, 2016 6:46 am

Re: Adding range of account [SOLVED]

Postby HPDeskJet » Tue Nov 22, 2016 8:34 am

Hi Pat -

I am assuming you are after a balance for those accounts.

Try this:

Code: Select all
=GL("Cell","Balance","000-1000-00..000-1500-00")-GL("Cell","Balance","000-1200-00")


-HP
HPDeskJet
 
Posts: 171
Joined: Tue Sep 06, 2011 9:20 am

Re: Adding range of account

Postby pblais » Tue Nov 22, 2016 8:59 am

Thank you very much!
pblais
 
Posts: 2
Joined: Tue Nov 22, 2016 6:46 am


Return to Ask the Community

Who is online

Users browsing this forum: No registered users and 1 guest