adding diff value
 

Yrly Income Tax (15%) Tax (15%) Net Yearly
204000 30600 Tax Payeer ?
72000 10800 Non Tax Payeer 0
3400 510 Non Tax Payeer 0
176000 26400 Tax Payeer ?
162000 24300 Tax Payeer ?

Add 15% tax only "Tax Payeer".

adding diff value
 

Pravin Chalise;338021 Wrote:
Yrly Income Tax (15%) Tax (15%) Net Yearly
204000 30600 Tax Payeer ?
72000 10800 Non Tax Payeer 0
3400 510 Non Tax Payeer 0
176000 26400 Tax Payeer ?
162000 24300 Tax Payeer ?

Add 15% tax only "Tax Payeer".

Hi,

I suppose you need something like =if(a3="Tax Peeyer",income*1.15,"")
( your explanation is a little short I'm afraid) ;-)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94542