Thread: "IF" Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
arno
 
Posts: n/a
Default "IF" Formula
If cellA IS between 3,000 & 5,000 multiply by 20%

=if(and(a1=3000,a1<=5000), a1*0.2, a1)

arno
Reply With QuoteReply With Quote