+ Reply to Thread
Results 1 to 6 of 6

What formula to use the multiplication

  1. #1
    Registered User
    Join Date
    05-24-2012
    Location
    chennai,india
    MS-Off Ver
    Excel 2007
    Posts
    3

    What formula to use the multiplication

    Hi All,

    This is my first thread, therefore please excuse me if i have not followed the correct rules. I would like to thank you all in advance for your help.

    Would you know what formula i could use to continue the multiplication without error values.

    please see attachement

    regards,

    ashraf.
    Attached Files Attached Files

  2. #2
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    604

    Re: What formula to use the multiplication

    Hi Ashraf

    Welcome to the forum. =IF(ISTEXT(C6),"",C6*E6) for that F6. I see that you've "paired" formulae down the column so you should be able to figure it out for the others from this formula.

    Cheers

    Russell
    If I helped, please don't forget to add to my reputation. (click on the star below the post)

    If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.

    Failure is not falling down but refusing to get up.

  3. #3
    Registered User
    Join Date
    05-24-2012
    Location
    chennai,india
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: What formula to use the multiplication

    Thanks for your reply. also, i need formula for F3

    ASHRAF

  4. #4
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    604

    Re: What formula to use the multiplication

    Ok, let's go from the other angle - =IF(ISNUMBER(C3),C2*E3,"")

    and then copy down but adjust as per your requirements.

    I'll be offline for a while now.
    Last edited by Russell Dawson; 05-24-2012 at 09:46 PM. Reason: Typo

  5. #5
    Registered User
    Join Date
    05-24-2012
    Location
    chennai,india
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: What formula to use the multiplication

    Ok. Thanks..

    Ashraf.

  6. #6
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    604

    Re: What formula to use the multiplication

    Hi Ashraf,

    I'm not sure whether I fully understand but let me know if the attached gives the correct result.

    Regards

    Russell
    Attached Files Attached Files

+ Reply to Thread

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