Results 1 to 6 of 6

formula that does simple math a specific number of times

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2007
    Posts
    9

    formula that does simple math a specific number of times

    This site looks awesome. It's unbelievable that so many people are willing to take time to help others.

    Not sure if this is the right forum but I need to write a formula that does simple Math by adding 1 to a cell based on certain criteria then stop once that criteria is met a certain number of times which is denoted in one of my cells.

    If F10 is > than 0 then G11 = F11 + 1 if True or = F11 if False
    If G10 is > than 0 then H11 = G11 +1 if True or = G11 if False
    If H10 is > than 0 then I11 =H11 + 1 if True or = H11 if False
    If I10 is > than 0 then J11 = I11 +1 if True or = I11 if False

    This Formula continues in a series all the way through W10

    Let's say D11 has the numeral 4, I need the above formula to stop adding +1 after the 4th time the formula comes back true:
    Last edited by salex; 04-22-2007 at 08:44 AM.

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