Hi,
I’m having trouble with correct syntax for this:
=E3/120*100*(G3="STD"),OR=E3*(G3="ZERO")
Trying to make a UK VAT spreadsheet.
Column E is INCLUDING VAT.
Column F is EXCLUDING VAT.
Column G is VAT RATE (either “ZERO” or “STD”)
Syntax for the first part works fine.
I am struggling with the OR part after the comma.
Can anyone help me out?
Many thanks!
Please put backticks around code, otherwise asterisks are parsed as markup. Alternatively, indent the code with four spaces.
In programming, ‘either/or’ is performed with if x then y else z and it works the same in LibreOffice (and other spreadsheet software).
In Calc, the IF function has these three parameters too: IF(test value; then value; else value). In your case, given that the value of G3 is always either ZERO or STD, you can just check for one in F3:
=IF(G3="STD"; E3/1.2; E3)
If the VAT tarriff is standard, divide the netto value by 1.2 (if your locale uses a decimal comma, use that), else use the netto value as bruto value.
Thank you so much bencomp.
Not only does it work, I now understand the structure too.
Dank u zeer