# Cell referencing two columns with conditions

1. ## Cell referencing two columns with conditions

hi,
Please assist in creating a formula related to cell referencing, described as follow,
I have two colums, ex sheet 1 named jentry , d9 = debit and e9= credit. in sheet 2, e2, a formula referencing to both D9 and E9 , with conditions that if d9 will be with value more than 0, use d9 and if E9 will be with value >0 use -(minus) e9 , and if both them will be with value less that 0 or both column with value ignore , or it should be that only one column D9, or E9 will be with value.
I already created one but still does not fit my requirement
=IF(AND(jentry!D9>0,jentry!D9>0),+jentry!D9,IF(AND(jentry!D9>0,0),+jentry!D9,IF(AND(jentry!E9>0,jentry!E9>0),-jentry!E9)))

I attached my template for reference

Ofel

2. ## Re: Help with formula

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

3. ## Re: Formula problem

Hi galang,

Change your title again and attach a sample workbook ( if possible ) without sensitive data including before and outcome that you want so it will be easier for people to understand and help with your problem.

4. ## Re: Cell referencing two columns with conditions

Hi,
Problem solved formula that meet my requirement as follows
=IF(AND(jentry!D25>0,jentry!E25>0),0,IF(AND(jentry!D25<0,jentry!E25<0),0,IF(AND(jentry!D25>0,jentry!E25<0),0,IF(AND(jentry!D25<0,jentry!E25>0),0,IF(jentry!D25>0,+jentry!D25,IF(jentry!E25>0,-jentry!E25,0))))))

Thanks a lot
Ofel

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1