+ 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
    7

    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
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,143
    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 in The Sun. Building things. Maybe see you next Winter! :)
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,621

    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)

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