+ Reply to Thread
Results 1 to 9 of 9

Excel 2007 : Sum of B * E = into box F with no Value error

  1. #1
    Registered User
    Join Date
    05-10-2012
    Location
    Vancouver
    MS-Off Ver
    Excel 2007
    Posts
    11

    Sum of B * E = into box F with no Value error

    I'm having problems with my sum of B * E= into F. when boxes B & E are empty "value!" error pops up. How would I do this to remove the value error?

    Thanks!

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Sum of B * E = into box F with no Value error

    Maybe

    =IF(COUNT(B1,E1)=2,B1*E1,"")
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Myrtle Beach, South Carolina
    MS-Off Ver
    =IF(Win 7,"Excel 2010","Mac Excel 2011")
    Posts
    104

    Re: Sum of B * E = into box F with no Value error

    write the formula =IFERROR(your formula)

  4. #4
    Registered User
    Join Date
    05-10-2012
    Location
    Vancouver
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Sum of B * E = into box F with no Value error

    Quote Originally Posted by jakeisbill View Post
    write the formula =IFERROR(your formula)
    =IFERROR(=sum b1*e1) ?

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Sum of B * E = into box F with no Value error

    Hi Bill,

    If you went this route then it would be,

    =IFERROR(value,value_if_error)
    =IFERROR(B1*E1,"")

  6. #6
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Myrtle Beach, South Carolina
    MS-Off Ver
    =IF(Win 7,"Excel 2010","Mac Excel 2011")
    Posts
    104

    Re: Sum of B * E = into box F with no Value error

    Thanks Jeff, Sorry about the brevety of my last post.

  7. #7
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Sum of B * E = into box F with no Value error

    No worries.

    Here's a little tip to copy the format of a formula so you get =IFERROR(value,value_if_error) without having to type it out.

    Place your cursor in a cell and begin typing out what you are searching. Once the formula comes up, hit tab to fill it out to =IFERROR(

    Now select Ctrl + Shift + A and you will get =IFERROR(value,value_if_error) and not just copy and paste to wherever.

  8. #8
    Registered User
    Join Date
    05-10-2012
    Location
    Vancouver
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Sum of B * E = into box F with no Value error

    Thanks alot Jeff!

  9. #9
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Sum of B * E = into box F with no Value error

    You're very welcome Bill. Glad you got it all sorted out and thanks for the feedback

+ 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