+ Reply to Thread
Results 1 to 5 of 5

if blank cell, don't calculate

  1. #1
    bj
    Guest

    RE: if blank cell, don't calculate

    What cell do you want to check if blank"

    Try
    =if(yourcell="","",your equation)

    "Dan" wrote:

    > Hello,
    >
    > I was wondering how i could work in an if statement to check if the cell is
    > blank, is do nothing, if it contains a number for it to perform the following
    > function:
    >
    > =SUM(IF(make!$A$2:$A$9571=finally!Q2,make!$C$2:$C$9571,0),0)
    >
    > I'm trying to save some time because in some rows there is only 3 cells that
    > contain a number and 30000 parts, it takes like 5 minutes for it to fill down
    > and calculate.
    >
    > Thanks in advance!
    >
    > Dejan


  2. #2
    Dan
    Guest

    RE: if blank cell, don't calculate

    Hey,

    Thanks, that works.


    "bj" wrote:

    > What cell do you want to check if blank"
    >
    > Try
    > =if(yourcell="","",your equation)
    >
    > "Dan" wrote:
    >
    > > Hello,
    > >
    > > I was wondering how i could work in an if statement to check if the cell is
    > > blank, is do nothing, if it contains a number for it to perform the following
    > > function:
    > >
    > > =SUM(IF(make!$A$2:$A$9571=finally!Q2,make!$C$2:$C$9571,0),0)
    > >
    > > I'm trying to save some time because in some rows there is only 3 cells that
    > > contain a number and 30000 parts, it takes like 5 minutes for it to fill down
    > > and calculate.
    > >
    > > Thanks in advance!
    > >
    > > Dejan


  3. #3
    Dan
    Guest

    if blank cell, don't calculate

    Hello,

    I was wondering how i could work in an if statement to check if the cell is
    blank, is do nothing, if it contains a number for it to perform the following
    function:

    =SUM(IF(make!$A$2:$A$9571=finally!Q2,make!$C$2:$C$9571,0),0)

    I'm trying to save some time because in some rows there is only 3 cells that
    contain a number and 30000 parts, it takes like 5 minutes for it to fill down
    and calculate.

    Thanks in advance!

    Dejan

  4. #4
    bj
    Guest

    RE: if blank cell, don't calculate

    What cell do you want to check if blank"

    Try
    =if(yourcell="","",your equation)

    "Dan" wrote:

    > Hello,
    >
    > I was wondering how i could work in an if statement to check if the cell is
    > blank, is do nothing, if it contains a number for it to perform the following
    > function:
    >
    > =SUM(IF(make!$A$2:$A$9571=finally!Q2,make!$C$2:$C$9571,0),0)
    >
    > I'm trying to save some time because in some rows there is only 3 cells that
    > contain a number and 30000 parts, it takes like 5 minutes for it to fill down
    > and calculate.
    >
    > Thanks in advance!
    >
    > Dejan


  5. #5
    Dan
    Guest

    RE: if blank cell, don't calculate

    Hey,

    Thanks, that works.


    "bj" wrote:

    > What cell do you want to check if blank"
    >
    > Try
    > =if(yourcell="","",your equation)
    >
    > "Dan" wrote:
    >
    > > Hello,
    > >
    > > I was wondering how i could work in an if statement to check if the cell is
    > > blank, is do nothing, if it contains a number for it to perform the following
    > > function:
    > >
    > > =SUM(IF(make!$A$2:$A$9571=finally!Q2,make!$C$2:$C$9571,0),0)
    > >
    > > I'm trying to save some time because in some rows there is only 3 cells that
    > > contain a number and 30000 parts, it takes like 5 minutes for it to fill down
    > > and calculate.
    > >
    > > Thanks in advance!
    > >
    > > Dejan


+ 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