+ Reply to Thread
Results 1 to 5 of 5

Newbie! Help with a formula

  1. #1
    Registered User
    Join Date
    03-29-2014
    Location
    U.S.
    MS-Off Ver
    Office 2010
    Posts
    3

    Unhappy Newbie! Help with a formula

    Ok, These are the three formula's. How do I combine them or can I.

    =IF((B2="GOV"),[@[Gal Billed]]/1000*1.5)
    =IF((B2="NPROFIT"),[@[Gal Billed]]/1000*2,0)
    =IF((B2="COM"),[@[Gal Billed]]/1000*3)

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,772

    Re: Newbie! Help with a formula

    you could try something like this…
    =IF(B2="GOV",[@[Gal Billed]]/1000*1.5,IF(B2="NPROFIT",[@[Gal Billed]]/1000*2,IF(B2="COM",[@[Gal Billed]]/1000*3,"")))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    03-29-2014
    Location
    U.S.
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: Newbie! Help with a formula

    Quote Originally Posted by Sambo kid View Post
    you could try something like this…
    =IF(B2="GOV",[@[Gal Billed]]/1000*1.5,IF(B2="NPROFIT",[@[Gal Billed]]/1000*2,IF(B2="COM",[@[Gal Billed]]/1000*3,"")))
    Thanks, I will give it a try.

  4. #4
    Registered User
    Join Date
    03-29-2014
    Location
    U.S.
    MS-Off Ver
    Office 2010
    Posts
    3

    Cool Re: Newbie! Help with a formula

    Quote Originally Posted by Sambo kid View Post
    you could try something like this…
    =IF(B2="GOV",[@[Gal Billed]]/1000*1.5,IF(B2="NPROFIT",[@[Gal Billed]]/1000*2,IF(B2="COM",[@[Gal Billed]]/1000*3,"")))
    You are awesome! Thanks again.

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,772

    Re: Newbie! Help with a formula

    you're welcome. BTW, you had this /1000*2,0) in one of the statements, if you want an alternative output instead of a blank change this /1000*3,""))) to this /1000*3,0))) and it will return a zero instead. If you issue is solved don't forget to mark your post as solved using the thread tools at the top and since you're new to the forum you can say thank you by clicking on the "* Add reputation" part at the bottom of the person's post as that is how we advance in this forum.

+ 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. Formula assistance for simple banking record
    By JamFam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2013, 02:09 PM
  2. [SOLVED] Please help a newbie with IF formula
    By hshimamura in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-26-2013, 12:25 PM
  3. Newbie help with simple % formula please
    By mturmell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2007, 05:09 PM
  4. Need help with Formula ~ Newbie
    By sricomm in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-03-2006, 12:06 AM
  5. Newbie needs help deciphering formula.
    By Grimzby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2006, 11:50 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