+ Reply to Thread
Results 1 to 2 of 2

Filling Cell Based on Two Other Formulas

  1. #1
    Registered User
    Join Date
    01-05-2016
    Location
    Beloit, WI
    MS-Off Ver
    2013
    Posts
    1

    Exclamation Filling Cell Based on Two Other Formulas

    Hi,

    I am trying to create a calculator that I can put in a number in cells B3 and B4 and it will calculate the right price. However, the price is based on a tiered system and at a certain tier there are free users. I want the calculator to provide the right number of free users (cell B16) based on input from cell B3, but if there is nothing, or too low of a number in cell B4, cell B16 will be 0. I want it to recognize that if I have 2 in cell B4, B16 will also only be 2. But if I have 10 in B4, then B10 would be 2, 3, or 5. Right now, my input for cell B4 is 2, so cell B16 should also be 2, but the formula is giving me 5 because of my input in cell B3.

    This is the formula I am working with for cell B16:
    =IF(B4<2,0,IF(AND(B3>=A11,B3<=B11),2,IF(AND(B3>=A12,B3<=B12),3,IF(B3>=A13,5,IF(B3<=B10,0,)))))
    Last edited by csheedy; 01-05-2016 at 04:12 PM.

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Filling Cell Based on Two Other Formulas

    Quote Originally Posted by csheedy View Post
    Hi,

    ..., my input for cell B4 is zero, so cell B16 should also be 0, but the formula is giving me 5 because of my input in cell B3. ...
    I use your formula and B16 show me 0 as expected.

+ 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] Formula for Filling Data based on Criteria from another cell
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-02-2015, 01:27 AM
  2. Filling a cell with YES based on data from another sheet
    By smartcard in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-01-2014, 07:26 AM
  3. Filling a series of formulas with weird cell formatting
    By eshortt84 in forum Excel General
    Replies: 3
    Last Post: 08-08-2013, 02:28 PM
  4. [SOLVED] Pre-filling data based on a cell
    By beleza.jake in forum Excel General
    Replies: 15
    Last Post: 09-05-2012, 05:20 PM
  5. Replies: 1
    Last Post: 06-11-2012, 02:37 PM
  6. Replies: 2
    Last Post: 01-26-2011, 02:13 PM
  7. Filling a cell based on another cell partial data
    By smartcard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-26-2010, 04:18 AM

Tags for this Thread

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