Thread: IF THEn Formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default IF THEn Formula

=if(a120000,.04,if(a210000,.06,.08))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

" 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