+ Reply to Thread
Results 1 to 3 of 3

If/Then Process

  1. #1
    Registered User
    Join Date
    10-03-2015
    Location
    Northern, Alberta
    MS-Off Ver
    2016
    Posts
    50

    If/Then Process

    I know that would be really great. But it is over my old head.
    I'm trying to calculate a group of cell's from a starting number and incrementing upward on an option of either percent (%) or a numerical number like .01 grains.
    I think a box with 2 buttons with the option buttons to instruct Excel either 1). Percent, or 2) incremental amount.

    I think an If/Then statement would say is "If Percent Button is chosen calculate (#*%)+#. In other words =C4*C3)+C4 OR
    If Incremental is chosen Then calculate (#*#)+#. C4+D3.

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: If/Then Process

    With data validation in C1 (source: Percentage, Amount), C5=IF(C1="Percentage",C3*(1+C4/100),C3+C4)
    Attached Files Attached Files

  3. #3
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: If/Then Process

    Another interpretation...
    Attached Files Attached Files
    Last edited by Croweater; 06-03-2023 at 09:06 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. PROCESS TRACKING-Process status should be Displayed base from the next blank Cell
    By RAMILJAYLDOMA in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-16-2019, 09:17 AM
  2. Kill a second Excel process from the first excel process
    By sebair in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2012, 05:40 PM
  3. Automate process
    By kamalthakur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2010, 11:27 AM
  4. If/then Process?
    By Zane B Stein in forum Excel General
    Replies: 1
    Last Post: 12-20-2005, 11:27 AM
  5. Iterative process,
    By bioyyy in forum Excel General
    Replies: 5
    Last Post: 11-30-2005, 10:10 PM
  6. How to count process running time ( process not finished)
    By miao jie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2005, 06:06 AM
  7. [SOLVED] How to count process running time ( process not finished)
    By miao jie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2005, 02:06 AM

Tags for this Thread

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