Thread: multiple IF function
View Single Post
  #4  
Old 03-22-2007, 05:54 PM
daddylonglegs's Avatar
daddylonglegs daddylonglegs is offline
Forum Moderator
  
Join Date: 14 Jan 2006
Location: England
Posts: 5,166
daddylonglegs is a jewel in the rough
You can do this without If functions.

If you have annual salary in A1 this will give total income tax payable in the year

=SUMPRODUCT(--(A1>{5035,7185,38335}),A1-{5035,7185,38335},{0.1,0.12,0.18})
Reply With Quote