Help - Excel Formula needed

New Contributor

I have a total wage in column A, in Column B I want to work out the tax roughly with a formula of ….. what is 20% of column A once it exceeds $361 

 

can anyone help me with this 

2 Replies

@Samos70 Try something like this:

Screenshot 2022-10-18 at 05.04.56.png

That is perfect, very much appreciated