Results 1 to 9 of 9

How to sum 3 or more results in 1 cell

Threaded View

tariqnaz2005 How to sum 3 or more results... 03-14-2010, 08:52 AM
zbor Re: How to sum 3 or more... 03-14-2010, 09:32 AM
tariqnaz2005 Re: How to sum 3 or more... 03-14-2010, 09:49 AM
tariqnaz2005 Re: How to sum 3 or more... 03-14-2010, 10:00 AM
Marcol Re: How to sum 3 or more... 03-14-2010, 10:13 AM
zbor Re: How to sum 3 or more... 03-14-2010, 10:21 AM
tariqnaz2005 Re: How to sum 3 or more... 03-14-2010, 10:26 AM
zbor Re: How to sum 3 or more... 03-14-2010, 10:30 AM
tariqnaz2005 Re: How to sum 3 or more... 03-14-2010, 10:42 AM
  1. #1
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Thumbs up How to sum 3 or more results in 1 cell

    Hi dears,

    This thing stuck me up..may be i wil be little for you guys..bue very hard for me at the moment..

    I have Cell A1 and B1..

    Cell A1 is for Number of Days..
    Cell B1 is for an amount which is based on days..

    I have 3 kind of Rates..like..days from 1 to 10 is 3 USD
    Days 11 to 20 is 6 USD and Days 20 to onward is 12 USD.

    Now what I want if Cell A1 has days "5" then B1 should give me result 5x3 = "15", but if A1 has days 15 than B1 should give me result "60" because first 10 days (10x3) and remaing 5 days (5x6) total 30 and as well as if days are more than 20 than same practice..

    How i solve it..

    Thanks in advance for your costly time and help.
    Last edited by tariqnaz2005; 03-14-2010 at 10:52 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1