Search : in
By :

If condition in excel

Last answer on Jun 30, 2009 6:38:54 pm BST nadia, on May 23, 2009 6:37:41 am BST 
 Report this message to moderators

Hello,
i want to implement the IF condition in Excel,the logic is if my sales entry is of A type then dedudct 16%sales tax on total sale and if my sales entry is of B type then deduct nothing.

Configuration: Windows XP Internet Explorer 6.0

Best answers for « if condition in excel » in :
Colouring cells on conditions Show Colouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...

1

 roja, on Jun 30, 2009 6:38:54 pm BST
  • +4

Write formula:
=IF(A2="a",100000-(100000*16%),B2)
where A2=cell name representing A or B
100000 is total sales value

Reply to roja