+ Reply to Thread
Results 1 to 4 of 4

if statement with caclulation

  1. #1
    Registered User
    Join Date
    11-13-2012
    Location
    WA
    MS-Off Ver
    Excel 2010
    Posts
    42

    Angry if statement with caclulation

    Hi all I am trying to figure out this if statement and I am hitting road blocks please help!

    I want to have the following calculations done based on an if statement if possible.

    If cell A6 equals or is greater than 2500 then I want cell C12 to calculate a total of 10% of the value in cell A6
    If cell A6 has a value of less than 2500 I want cell C12 to automatically put a total of 250 as the value.

    How on this green earth do I make this happen.

    I am running Office Pro 2010 on a windows 10 machine.
    I know I know its old but I hate change

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: if statement with caclulation

    In C12

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    11-13-2012
    Location
    WA
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: if statement with caclulation

    This worked like a charm thank you very much.

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,899

    Re: if statement with caclulation

    Another way:

    =MAX(250,A6*10%)

+ 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. compile error expected line number statement end statement
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2014, 10:12 AM
  2. VBA Compile Error : line number or label or statement or end of statement
    By excellearner121 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 06:41 PM
  3. Replies: 4
    Last Post: 06-01-2012, 10:05 AM
  4. Replies: 4
    Last Post: 05-16-2012, 05:33 PM
  5. Date Caclulation based on fixed date
    By sandeepn in forum Excel General
    Replies: 2
    Last Post: 05-20-2011, 10:46 AM
  6. [SOLVED] Utilize a Select Case Statement in Target Intersect Statement
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 08:55 PM
  7. Caclulation
    By ice in forum Excel General
    Replies: 1
    Last Post: 03-06-2008, 04:39 PM

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