+ Reply to Thread
Results 1 to 10 of 10

IF Function to Numbers

  1. #1
    Registered User
    Join Date
    07-18-2013
    Location
    Chile
    MS-Off Ver
    Excel 2013
    Posts
    29

    IF Function to Numbers

    I have been looking for over an hour online and cant figure it out.
    Basically I have an if formula, IF(D5=20,2000,)&IF(D5=16,1500,) and it works fine. However, I want to autosum the results of that column with that formula. Ive learned its in text, but cant convert it, also I would like to make it so if I apply that formula to the rest of the column it will give me a number format, as it will be added.

    Thanks in advance

  2. #2
    Forum Contributor
    Join Date
    07-16-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    176

    Re: IF Function to Numbers

    need more clarification or example please

  3. #3
    Forum Contributor
    Join Date
    06-26-2013
    Location
    Makati
    MS-Off Ver
    Excel 2010
    Posts
    138

    Re: IF Function to Numbers

    Hi,
    try..

    =IF(D5=20,2000,IF(D5=16,1500,))

  4. #4
    Registered User
    Join Date
    07-18-2013
    Location
    Chile
    MS-Off Ver
    Excel 2013
    Posts
    29

    Re: IF Function to Numbers

    For example, I have a column with the formula, that goes a couple of cells down, F(D5=20,2000,)&IF(D5=16,1500,). Obviously I get numbers here right, I want to autosum these numbers, autosum gives me Zero.
    Last edited by Yanezez; 07-19-2013 at 02:10 AM.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: IF Function to Numbers

    Hi and welcome to the forum

    when you combine/concatenate numbers with & (or with concatenate() ), the answer is always text (and so does left(), mid() and right()). so, given that the criteria is met, you will have text that says 20001500.

    assuming you have a whole range of "text" like that, are you looking to add...
    20001500 + 20001500 + 200001500 for rows 5:7
    OR would you want...
    2000+1500+2000+1500+2000+1500
    or what answer would you expect, given that data?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: IF Function to Numbers

    Perhaps post a small sample sheet ?

  7. #7
    Registered User
    Join Date
    07-18-2013
    Location
    Chile
    MS-Off Ver
    Excel 2013
    Posts
    29

    Re: IF Function to Numbers

    Quote Originally Posted by FDibbins View Post
    Hi and welcome to the forum

    when you combine/concatenate numbers with & (or with concatenate() ), the answer is always text (and so does left(), mid() and right()). so, given that the criteria is met, you will have text that says 20001500.

    assuming you have a whole range of "text" like that, are you looking to add...
    20001500 + 20001500 + 200001500 for rows 5:7
    OR would you want...
    2000+1500+2000+1500+2000+1500
    or what answer would you expect, given that data?

    Yeah, its text. I want it to autosum a column full of numbers I get using an IF function, and to do it automatically.Guía Ampuero.xlsx


    I dont know if u can see it, but i want K3 to be the autosum of Column H (The column that has the IF Function)

    Its in spanish, but the general idea is the same.

  8. #8
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: IF Function to Numbers

    Try =IF(F6=20,2000,IF(F6=16,1500,"")) in H6 and pull down as needed

  9. #9
    Registered User
    Join Date
    07-18-2013
    Location
    Chile
    MS-Off Ver
    Excel 2013
    Posts
    29

    Re: IF Function to Numbers

    Quote Originally Posted by Pepe Le Mokko View Post
    Try =IF(F6=20,2000,IF(F6=16,1500,"")) in H6 and pull down as needed
    Almost! haha, thanks for the try though.


    If I do that and drag down it does convert them into numbers, as long as F6 is 20, if its 16 all i get in the H Column is "#######".

  10. #10
    Registered User
    Join Date
    07-18-2013
    Location
    Chile
    MS-Off Ver
    Excel 2013
    Posts
    29

    Re: IF Function to Numbers

    Quote Originally Posted by Yanezez View Post
    Almost! haha, thanks for the try though.


    If I do that and drag down it does convert them into numbers, as long as F6 is 20, if its 16 all i get in the H Column is "#######".
    Never mind, it worked! Thanks a lot!

+ 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. Replies: 6
    Last Post: 12-22-2012, 05:04 PM
  2. Excel 2007 : 'Right' function for numbers
    By Matt Parsons in forum Excel General
    Replies: 5
    Last Post: 10-11-2011, 11:17 AM
  3. Replies: 12
    Last Post: 04-24-2011, 05:45 PM
  4. [SOLVED] Function to write out numbers
    By Mark Williams in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] Function to write out numbers
    By Mark Williams in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02: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