Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plotting column chart whch colors the bars diff for diff comm | Charts and Charting in Excel | |||
SUMIF formula required to search for 2 diff values in 2 diff colum | Excel Worksheet Functions | |||
how you make links between diff. cells on diff. work sheets | Excel Worksheet Functions | |||
Adding values from 1 col based on value in diff col | Excel Discussion (Misc queries) | |||
Date Diff | Excel Discussion (Misc queries) |