+ Reply to Thread
Results 1 to 3 of 3

If senarios

  1. #1
    Registered User
    Join Date
    03-10-2016
    Location
    Boston,MA
    MS-Off Ver
    2010
    Posts
    8

    If senarios

    Hello everyone,

    I hope someone can help we with this. I am working on this project and i am trying to figure out a formula to use for the example below. Basically what i am trying to do is say, if column B has a minus (-) sign in front, make column E a negative, if not leave it as a positive.

    Basically, if the flow column has a + in front it is an inflow and if it is a - it is an outflow.


    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello jojo2016,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: If senarios

    Hi jojo2016
    Welcome to the forum.

    Mostly this Sub Forum is used for you to say hello and introduce yourself.

    If you need help then for a formula problem you would be best to start a Thread here:
    https://www.excelforum.com/excel-for...and-functions/

    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

+ 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] Sum some columns based on row color
    By DanS52 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2017, 09:59 AM
  2. [SOLVED] Criteria for color and columns
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2015, 10:30 AM
  3. Color a few columns in a row with a click
    By sulbaran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2014, 01:08 PM
  4. First two columns are reversed in color
    By benvc in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-26-2014, 12:20 AM
  5. Listbox Row Color, Columns Alignment, Columns Borders
    By BrianAll in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 10:53 AM
  6. Format cell color on change, how to change the color in other columns as well?
    By s80NL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2007, 09:24 PM
  7. Sort columns by color
    By danpajo in forum Excel General
    Replies: 1
    Last Post: 09-01-2005, 01:05 AM

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