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.
Colouring cells on conditions ShowColouring 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...