Embedded IF function with ISNUMBER(SEARCH)

[Nicola24297]

I'm trying to calculate the VAT on the attached file, but there are various different VAT treatments depending on the type of sale.

I have included the formula I am trying to use but it's not working!

Would someone be able to have a look and see if they can fix it?

Thanks!

[AliGW]

What exactly does 20% of our revenue mean? Is that just VAT at 20%?

[Nicola24297]

Hi...yes, just 20% of the company's revenue, not the recharged amount.

Thank you!

[RhiSJ]

Your multiple if function is unclear, it should be

=IF(ISNUMBER(SEARCH("HTP",$A2)),$B2*0.2,  IF(ISNUMBER(SEARCH("Fee",$A2)), 0,  IF(ISNUMBER(SEARCH("Fine",$A2)), 0,  ($B2-$B2/(1.2)))))

IFS function also available

=IFS(ISNUMBER(SEARCH("HTP",$A2)),$B2*0.2, ISNUMBER(SEARCH("Fee",$A2)),0, ISNUMBER(SEARCH("Fine",$A2)),0, TRUE,($B2-$B2/(1.2)))

[AliGW]

You have solutions in post #3, so I have stood down.