+ Reply to Thread
Results 1 to 2 of 2

I need a simple IF fromula.

  1. #1
    Registered User
    Join Date
    04-07-2014
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    1

    I need a simple IF fromula.

    I'm having trouble with excel, so i have been watching training videos but i haven't figured out how to do a certain formula.
    Ill, to the best i can, explain what I need help with. On my sheet i have three quarters(B5:D5), and i want the sum of all three, but with my third quarter(D5) if the value is equal or greater than 600 i want to add 10% (Which is my G3) to that value, but not the rest (B5, C5)

    Thanks for taking the time and reading through my problem.

    PS: Yes i know that there're 4 quarters, but i haven't reached the fourth quarter yet.
    Last edited by Bawth; 04-07-2014 at 02:20 PM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: I need a simple IF fromula.

    =if(D5>=600, B5+C5+(D5*1.1), sum(B5:D5) )
    OR
    =if( D5>=600, Sum(B5:D5)+G3, sum(B5:D5))

    but with my third quarter(D5) if the value is equal or greater than 600 i want to add 10% (Which is my G3) to that value, but not the rest (B5, C5)
    if you dont want B5 or C5 and so just D5+G3
    then
    =if( D5>=600, D5+G3, sum(B5:D5))
    Last edited by etaf; 04-07-2014 at 03:17 PM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. [SOLVED] If SUM of fromula is Less than zero.
    By brutski in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2013, 04:01 PM
  2. excel fromula or macro required to do simple job
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-15-2013, 10:45 AM
  3. Selecting fromula
    By Krisverheyen in forum Excel General
    Replies: 7
    Last Post: 07-23-2009, 03:44 PM
  4. Need a fromula
    By comotoman in forum Excel General
    Replies: 3
    Last Post: 10-03-2005, 12:05 PM
  5. [SOLVED] Is there a fromula for TAB?
    By Bill Maxwell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2005, 03:06 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