Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: Continue the calculation but stops at 99 *

  1. #11
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,270
    Rep Power
    10
    Quote Originally Posted by learning View Post
    Ok, I did that and that's wonderful but how can I change the spreadsheet so I don't have to keep dragging it down? Is that possible? I thought that what the "limit" entry is suppose to do automatically. Isn't it?
    You could do that with a VBA Code.
    But that is realy trying to run before you can walk.
    Can you not just drag the formulas a long way down so that there is always enough. ?

    The "limit" entry is just a value used in the formula.
    The formulas give you no value ( "" ) or a value based on an equation depending on If the the condition is met
    https://support.office.com/en-us/art...c-aa8bbff73be2
    Last edited by DocAElstein; 01-24-2017 at 03:14 AM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!

  2. #12
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,270
    Rep Power
    10
    Quote Originally Posted by learning View Post
    .... I thought that what the "limit" entry is suppose to do automatically. Isn't it?
    Look at this for example

    Using Excel 2007 32 bit
    Row\Col
    F
    95
    =IF(G94>=$B$3,"",G94+1)
    Worksheet: Sheet1

    IF the value of cell G94 is greater than or equal to the calue in B3 ( the limit ) then the formula returns a value in the cell of ""
    "" is just Excel's way of saying nothing.
    Otherwise if that condition is not met the value returned to the cell is given by
    ( the value in cell G94 ) +1
    Last edited by DocAElstein; 01-23-2017 at 09:55 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!

  3. #13
    Junior Member
    Join Date
    Jan 2017
    Posts
    11
    Rep Power
    0
    This is not the thread I started, what happened? It looks like mine was hijacked. This is not a continuation of page 1










    _.___________________________________

    Moderator Note ( 15th Jan 2019 ): Changed title so that clicking on page 2 works... added a * after 99 in original title
    Last edited by DocAElstein; 01-15-2019 at 09:24 PM. Reason: Note about my title change

  4. #14
    Junior Member
    Join Date
    Jan 2017
    Posts
    11
    Rep Power
    0
    Hello,????

  5. #15
    Junior Member
    Join Date
    Jan 2017
    Posts
    11
    Rep Power
    0
    Ok, thanks again. I think at this point is to go to fiverr and find someone to fix it the way I want it for 5 dollars and just be done with it. Thanks again.

  6. #16
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,270
    Rep Power
    10
    Quote Originally Posted by learning View Post
    Hello,????
    Hello
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!

  7. #17
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    12
    Quote Originally Posted by learning View Post
    Ok, thanks again. I think at this point is to go to fiverr and find someone to fix it the way I want it for 5 dollars and just be done with it. Thanks again.
    In that case you are not learning, Learning.

  8. #18
    Junior Member
    Join Date
    Jan 2017
    Posts
    11
    Rep Power
    0
    I guess you're right snb, thanks for the observation.

  9. #19
    Junior Member
    Join Date
    Jan 2017
    Posts
    11
    Rep Power
    0
    See snb,
    It's a need vs. want vs. have to situation
    I don't need or have to learn excel
    I want to learn excel
    Just because I paid someone to fix my spreadsheet doesn't mean I've stopped wanting to learn excel.
    See there you posted a judgement like you know me and you don't.
    Thanks again.

Similar Threads

  1. TAT Calculation
    By pramodagroiya in forum Excel Help
    Replies: 5
    Last Post: 05-30-2016, 12:27 PM
  2. Replies: 1
    Last Post: 03-01-2015, 12:11 AM
  3. On Going Calculation
    By justme1052 in forum Excel Help
    Replies: 2
    Last Post: 12-31-2013, 02:06 AM
  4. Macro stops running if date is not in past...
    By Carlos Arruda in forum Excel Help
    Replies: 4
    Last Post: 03-10-2013, 04:33 PM
  5. Replies: 2
    Last Post: 09-16-2012, 02:28 AM

Posting Permissions

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