| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=if using cells with % or text
I would like to do the following :
Look at cell a1 to see if the letter in that cell is either S (for standard VAT) or Z (for Zero Vat). Then depending on what letter is cell a1, I would like to multiply an amount in cell a2 by either 17.5% if S or 0% if Z. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=if using cells with % or text
spudsnruf,
In cell A3 enter: =If(A1="S",A2*0.175,0) Now that would calculate the amount of tax (the amount that needs to be added to the subtotal). If you want, you can calculate the total like this: =If(A1="S",A2*1.175,A2) HTH, Conan "spudsnruf" wrote in message ... I would like to do the following : Look at cell a1 to see if the letter in that cell is either S (for standard VAT) or Z (for Zero Vat). Then depending on what letter is cell a1, I would like to multiply an amount in cell a2 by either 17.5% if S or 0% if Z. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=if using cells with % or text
Brilliant. Thanks. Appreciate it.
"Conan Kelly" wrote: spudsnruf, In cell A3 enter: =If(A1="S",A2*0.175,0) Now that would calculate the amount of tax (the amount that needs to be added to the subtotal). If you want, you can calculate the total like this: =If(A1="S",A2*1.175,A2) HTH, Conan "spudsnruf" wrote in message ... I would like to do the following : Look at cell a1 to see if the letter in that cell is either S (for standard VAT) or Z (for Zero Vat). Then depending on what letter is cell a1, I would like to multiply an amount in cell a2 by either 17.5% if S or 0% if Z. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions | |||
| Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
| How to input additional text to multiple of existing cells that has text | Excel Worksheet Functions | |||
Linear Mode
