IF STATEMENT - PLACEMENT OF VALUE IN THE CORRECT CELL
 

Hello!

The situation is as follows:

Sheet #1 contains the following:

Tax Paid $120
Tax Collected $100
-----------------------------------------------------------
Net Payable / (Receivable) ($20)
[Tax Paid is deducted from Tax Collected]

Sheet #2 contains the following headings, which is a journal voucher:

Account No Description Debit Credit

I need to come up with an if statement to place the net value from sheet #1 under the correct column of debit or credit:

1) If the value is negative then the tax is receivable should be place under 'Debit', say cell number D2 as a positive number
2) If the value is positive then the tax is payable and should be placed under 'Credit', say cell number E2, as a positive number
3) If the value is equal to zero then both cells, D2 & E2, should be zero.

Thanks
SJ

IF STATEMENT - PLACEMENT OF VALUE IN THE CORRECT CELL
 

in Sheet2

Assume cell with net value in sheet1 is C3

in Sheet2

D2 =if(Sheet1!C3<0,-Sheet1!C3,0
E2 =if(Sheet1!C30,Sheet1!C3,0)

Steve

On Wed, 11 Oct 2006 16:19:53 +0100, SSJ wrote:

Hello!

The situation is as follows:

Sheet #1 contains the following:

Tax Paid $120
Tax Collected $100
-----------------------------------------------------------
Net Payable / (Receivable) ($20)
[Tax Paid is deducted from Tax Collected]

Sheet #2 contains the following headings, which is a journal voucher:

Account No Description Debit Credit

I need to come up with an if statement to place the net value from sheet
#1 under the correct column of debit or credit:

1) If the value is negative then the tax is receivable should be place
under 'Debit', say cell number D2 as a positive number
2) If the value is positive then the tax is payable and should be placed
under 'Credit', say cell number E2, as a positive number
3) If the value is equal to zero then both cells, D2 & E2, should be
zero.

Thanks
SJ




--
Steve (3)

IF STATEMENT - PLACEMENT OF VALUE IN THE CORRECT CELL
 

Very simple! Thank you

SJ
----

"SteveW" wrote in message
news:op.tg9kp4a6evjsnp@enigma03...
in Sheet2

Assume cell with net value in sheet1 is C3

in Sheet2

D2 =if(Sheet1!C3<0,-Sheet1!C3,0
E2 =if(Sheet1!C30,Sheet1!C3,0)

Steve

On Wed, 11 Oct 2006 16:19:53 +0100, SSJ wrote:

Hello!

The situation is as follows:

Sheet #1 contains the following:

Tax Paid $120
Tax Collected $100
-----------------------------------------------------------
Net Payable / (Receivable) ($20)
[Tax Paid is deducted from Tax Collected]

Sheet #2 contains the following headings, which is a journal voucher:

Account No Description Debit Credit

I need to come up with an if statement to place the net value from sheet
#1 under the correct column of debit or credit:

1) If the value is negative then the tax is receivable should be place
under 'Debit', say cell number D2 as a positive number
2) If the value is positive then the tax is payable and should be placed
under 'Credit', say cell number E2, as a positive number
3) If the value is equal to zero then both cells, D2 & E2, should be
zero.

Thanks
SJ




--
Steve (3)