Thread: IF THEn Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Laura Cook[_2_] Laura Cook[_2_] is offline
external usenet poster
  
Posts: 18
Default IF THEn Formula
=IF(A1<10000,A1*0.08,IF( A120001,A1*0.04,A1*0.06))

Laura Cook


" wrote in
message ...
I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?


Reply With QuoteReply With Quote