View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kat Kat is offline
external usenet poster
 
Posts: 56
Default If than statement with multiple values

Hello,
Would I be able to create a if than statement for the following example.

If total is 0-99 than add 15
if total is 100-2000 than add 10%
if total is 2001-5000 than add 7%
if total is 5001-15000 than add 5%
if total is over 15000 than add 4%

Thanks!