+ Reply to Thread
Results 1 to 4 of 4

How can I have an idex formula and if zero in 1 cell?

  1. 10-11-2016, 09:12 AM #1
    jessicabahl
    jessicabahl is offline
    Registered User
    Join Date
    10-11-2016
    Location
    Brockton, MA
    MS-Off Ver
    2016
    Posts
    1

    Question How can I have an idex formula and if zero in 1 cell?

    I have created a Pricing Calculator to quote my customers. This calculator is very specific to the printing industry. The printing industry has many variables, like number of colors being printed, how many pieces, and how many locations as well as the cost of the blank garment.
    So sometimes I will need 4 cells to add up the locations and sometimes I only need 1. If I just delete the info in the cells I don't need for that particular Quote, then the formula is gone.
    I am not even sure how to ask exactly what I need. Sorry. This is my first post, but even after watching 20 Excel videos on Youtube, I cannot figure out what I need to do.

    I think what I need to happen (I don't know if it is possible) is to have an if zero enter zero, if otherwise enter the index formula in the same cell. When I try it, it doesn't work.

    Please help!
    Reply With QuoteRegister To Reply
  2. 10-11-2016, 09:56 AM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.85 (24051214))
    Posts
    8,818

    Re: How can I have an idex formula and if zero in 1 cell?

    perhaps this would help us if you mocked up what you needed

    =IF( 4cells , 4 cell index formula , 1 cell index formula )


    Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
    We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

    To attach a file to your post,
    click "Go advanced" (next to quick post),
    scroll down until you see "manage Attachments",
    click that and select "Choose File" (top Left corner).
    Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 10-11-2016, 10:08 AM #3
    FDibbins
    FDibbins is offline
    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,956

    Re: How can I have an idex formula and if zero in 1 cell?

    Hi, welcome to the forum

    As well as showing a sample WB, you could also share what formula/s you are trying to adjust?
    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
    Reply With QuoteRegister To Reply
  4. 10-11-2016, 10:09 AM #4
    FDibbins
    FDibbins is offline
    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,956

    Re: How can I have an idex formula and if zero in 1 cell?

    Hi, welcome to the forum

    As well as showing a sample WB, you could also share what formula/s you are trying to adjust?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] If cell has a formula, copy text to TextBox and leave formula unchanged in cell
    By yachrishere in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2016, 06:26 PM
  2. Formula Help - nested statements - different things if cell blank or cell part of formula
    By hirshy1230 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-14-2016, 03:53 PM
  3. value into Textbox equal idex column
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2016, 02:25 PM
  4. [SOLVED] Formula to return Blank cell if referenced cell has no entries, if not use formula
    By stpeter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2016, 01:41 PM
  5. Idex match or vlookup in combination of concatenate date cells with text?
    By EvoBob in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-21-2013, 03:25 AM
  6. populate cell with formula referenced from array, insert adjacent cell value into formula
    By globalfuture in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-07-2013, 08:34 AM
  7. Idex number relating to name
    By Back2Basics in forum Excel General
    Replies: 2
    Last Post: 02-12-2009, 06:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1