#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
plotting column chart whch colors the bars diff for diff comm Cathy Charts and Charting in Excel 5 March 19th 09 06:30 PM
SUMIF formula required to search for 2 diff values in 2 diff colum Lidy693 Excel Worksheet Functions 7 February 21st 09 09:45 PM
how you make links between diff. cells on diff. work sheets NYC-MIKE Excel Worksheet Functions 3 February 11th 08 05:05 PM
Adding values from 1 col based on value in diff col Big UT Fan Excel Discussion (Misc queries) 2 October 16th 06 08:44 PM
Date Diff Chip Pearson Excel Discussion (Misc queries) 1 October 25th 05 07:53 PM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"