Excel Help - Multiple If Commands

[Freakbro]

I am trying to automate the calculation of VAT within a table in Excel and have worked out how to calculate if it's standard or zero rated and return the correct VAT amount by using this formula

=IF(Table4[[#This Row],[Rate]]="Standard 20.00%",Table4[[#This Row],[Net]]*20%,0)

Which checks to see if the rate is "Standard 20%" and if not return a 0 (for Zero rated)

But to cover all possibilities, how would I insert a third variable of Reduced Rate VAT into that formula? so the 3 outputs are either

Table4[[#This Row],[Net]] x 20%
Table4[[#This Row],[Net]] x 5%
0

 

[Freakbro]

So I've now got this

=IF(Table4[[#This Row],[Rate]]="Standard 20.00%",Table4[[#This Row],[Net]]*20%,0, IF(Table4[[#This Row],[Rate]]="Reduced 5.00%",Table4[[#This Row],[Net]]*5%,0))

But that's not working, where am I going wrong?

Edit : Figured it out, thanks @EVH

This

=IF(Table4[[#This Row],[Rate]]="Standard 20.00%",Table4[[#This Row],[Net]]*20%,IF(Table4[[#This Row],[Rate]]="Reduced 5.00%",Table4[[#This Row],[Net]]*5%,0))

now works