Hi All,
can anyone please help me? I need a formula to return a pre-determanned tax value ( Col C ) where column A and B are the criteria
EG: If someone earns R 6613, his Tax will be R 672. So the formula needs to take the earnings "X" and it needs to return the value of Col C where X >= col A and <= col B
A B C
R 6581 R 6596 R 667
R 6597 R 6612 R 670
R 6613 R 6628 R 672
R 6629 R 6644 R 675
Thanks in advance!
Regards
Bookmarks