Thread: A formula that is: if the sum is this, then muliply by this?
View Single Post
  #1   Report Post  
Jenny
 
Posts: n/a
Default A formula that is: if the sum is this, then muliply by this?
I want a formula that will calculate like this:

If the total in this cell is between 75,000 and 99,999 then muliply it by
..30. If it's between 100,000 and 149,999 then muliply it by .80. Is this
possible?
Reply With QuoteReply With Quote