Thread: How do I enter formula sum(range+range)*0.15 sumif(range=3)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default How do I enter formula sum(range+range)*0.15 sumif(range=3)
If I interpret you correctly:

=SUM(Range1,Range2)*IF(SUM(Range3)<=3,0.15,1)

My assumption was that your wanted the sum of the first two ranges
regardless, and the multiplcation factor was what was dependend upon the
value of range3.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"tkw" wrote:

I'm not sure how to enter this formula:

I want to add two ranges and multiply the total by 0.15, but only if the
range of another cell is "less than or equal to" 3.
Reply With QuoteReply With Quote