Excel function to calculate tax on graduated scale,

[gkrotich2003]

For less than 30,000 tax at 0%, between 30,000 and 100,000, 15% and over 100,000 at 30%
An If function will do me good

 

[VoG]

This may help you McGimpsey & Associates : Excel : Using SUMPRODUCT() with variable rates

 

[Andrew Poulsom]

Welcome to MrExcel.

Look here:

McGimpsey & Associates : Excel : Using SUMPRODUCT() with variable rates

 

[gkrotich2003]

Welcome to MrExcel.

Look here:

McGimpsey & Associates : Excel : Using SUMPRODUCT() with variable rates

It is working out.

Many thanks