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
Thanks in advance
Ofel
Bookmarks