Forum Discussion
RE: Modern Excel webinars
Hello, I'm looking to include a formula in a cell but without the entry of a value. For example, I would like to be able to enter the value 100 in cell A1 and have the formula in the cell automaticall...
You can just refer to the cell which will contain the value in your formula, i.e. if you are calculating 20% VAT based on value in cell A1, the formula would read =IFERROR($A$1*0.20,””)
The IFERROR part just ensures you dont get an error when cell A1 contains no value.
The IFERROR part just ensures you dont get an error when cell A1 contains no value.
...if you want to add 20% VAT, showing total including cash tax, formula should be multiplied by 1.2. (0.2 gives the tax amount only).