+ Reply to Thread
Results 1 to 3 of 3

IF Statment Assistance Needed

  1. #1
    Registered User
    Join Date
    04-14-2014
    Location
    Louisville KY
    MS-Off Ver
    Excel 2010
    Posts
    9

    Thumbs up IF Statment Assistance Needed

    Hey -

    New to the forum, use excel on a daily basis but by no means a formula expert, and needing some help.

    This issue I am trying to write a formula for is this:

    I have an amount in column E2; I want to divide that amount by 2 and put the answer in column I2, but I only want to divide column E2 when column F2 and G2 are blank. If there is an amount in column F or G I want column H to stay blank.
    I know I am needing an IF statment but I cant seem to figure out how to exactly put it.

    E F G H
    1 Amount User 1 User 2 Split
    2 15.00 15.00
    3 10.00 5.00
    4 5.00 5.00

    Any help is appreciated. Hope that makes sense. Thanks!

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: IF Statment Assistance Needed

    Hi

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: IF Statment Assistance Needed

    For I2....

    Please Login or Register  to view this content.
    For H2 you want it to be blank if F2 and G2 have values in them but what if they both or any of them are blank?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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. HELP... Assistance needed Please!
    By MChase in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-23-2012, 11:08 AM
  2. V Lookup assistance Needed
    By jdk789 in forum Excel General
    Replies: 5
    Last Post: 09-05-2012, 04:47 AM
  3. if statment needed
    By megabytecompute in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-08-2008, 08:07 AM
  4. Code assistance needed
    By JimMay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-07-2006, 06:20 AM
  5. VBA Assistance Needed
    By RalphB in forum Excel General
    Replies: 5
    Last Post: 02-22-2006, 02:20 PM

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