Results 1 to 10 of 19

Thread: Continue the calculation but stops at 99 *

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #12
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    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!!

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
  •