Snasui Excel Forum

hi Dear,

I need formula to do accounting entries for calculation general provisioning.

if current month amount >previous month amount I need to Dr value in colour cells row Gen and Global Prov and Cr Doubtful and bad debt.if current month<previous month I need Dr value in colour cells row Doubtful and bad debt and Cr Gen and Global Prov but if current month =previous month I need blank cells (no entry).

note : current month is applied 1% to balance at other bank


Thanks

...

B6
=IF(C2<D2,B2,"")

B7
=IF(C2>D2,B2,"")

C6
=B7

C7
=B6

Norkaz

sorry it is not working.
I mean if c2>d2 it would Dr amount variance between c2 and d2 to Gen and Global Prov and amount variance also will go to Cr Doubtful and bad debt as well.
if c2<d2 it would Cr amount variance between c2 and d2 to Gen and Global Prov and amount variance also will go to C
Dr Doubtful and bad debt as well.
If c2=d2 the Dr and Cr would be nothing (blank).

Thank

...


B6
=IF(C2<D2,D2-C2,"")

B7
=IF(C2>D2,C2-D2,"")

C6
=B7

C7
=B6

If it's not the right solution, give us the excel sample file with the answers that it would be.

Norkaz

thank you it works.but if I need acc code instead.
for example if c2>d2 I need
Dr Cr
64280 38920
If c2<d2 I need
Dr Cr
38920 64280
I need Dr to come first
Else if c2=d2 I need nothing (blank)

here's attachment

...

The sample answer is really significant to understand in the same way, please enter the answers related to C2 and D2 values.

Norkaz

c2 is from balance multiplied with 1% and d2 is amount we had last month from bal last month*1% too.i want to debit Gen and global 64280 and credit to doubtful and bad debt 38920.so if c2>d2 I need
Dr Cr
64280 38920
If c2<d2 I need
Dr Cr
38920 64280
I need Dr to come first
Else if c2=d2 I need nothing (blank)

..

Hi guy,

It could come to the right solution obviously if you please provide the answers that it would be via the "EXCEL" attached.

The sample answers in the Excel attached are really important to understand in the same way together between questioner and answerer such as which cells or positions need to take the formulas or the way the formulas could be.


Otherwise, try this.

A8
=IF(C2=D2,"",IF(C2>D2,64280,38920))

B8
=IF(C2=D2,"",IF(A8=64280,38920,64280))

Norkaz

Thank you