Calculate VAT from a Yes No dropdown

[paul031971]

Hi There,

I wonder if anyone can help. I want to have the VAT added in a cell if a validation is "yes" and left blank if "no".

So on the attached sheet if column 16 = "S" then I would like it to calculate add 20% VAT to the value in column 15 and display that value in column 16. If the value = "Z" then I would like it to give a zero value in column 16.

I have put the VAT rate of 20 in the valdiation sheet as I thought this value could be drawn in from here incase the VAT rate changes from 20% in the future.

Is this possible? I have tried everything with my limited knowledge and cannot make this work.

Many thanks,

Paul

[AliGW]

Try this, if you must do it the way you have described:

=O16*VLOOKUP(P16,Validations!$A$4:$B$5,2,0)/100

Easier would be:

=IF(P16="S",O16*0.2,0)

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[paul031971]

Thank you AliGW your easier solution works perfectly. Thank you so much!

[AliGW]

You are very welcome!