+ Reply to Thread
Results 1 to 8 of 8

Adding £5 to a cell's formula, based on a dropdown result in another tab.

  1. 03-22-2018, 10:01 AM #1
    sdean
    sdean is offline
    Registered User
    Join Date
    03-22-2018
    Location
    Castleford, England
    MS-Off Ver
    10
    Posts
    15

    Adding £5 to a cell's formula, based on a dropdown result in another tab.

    Sorry, relative newbie here.

    I have a drop-down with two options in a cell in one tab - yes or no (Cell B7 - Tab is titled 'Details').
    If the drop down selection is yes, i would like £5 adding to the formula already in another cell in another tab (Cell B12 - Tab is titled 'Workings'). Currently, that cell has this formula: =B10*F3
    If the dropdown option selection is 'no', I don't want any amount adding to the value.

    I'm guessing it's something along these lines: =IF(Details!B7='Yes',5,0)+(B10*F3) This doesn't work however!

    Any help, much appreciated!
    Last edited by sdean; 03-22-2018 at 10:07 AM.
    Reply With QuoteRegister To Reply
  2. 03-22-2018, 10:06 AM #2
    davsth
    davsth is offline
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,210

    Re: Adding £5 to a cell's formula, based on a dropdown result in another tab.

    what is the dropdown? cell validation or a form control ? if a form control is the result stored in B7 or is that the cell the control is displayed in?

    what are the values in Details!B7 are they yes and no or say 1 and 2?
    Reply With QuoteRegister To Reply
  3. 03-22-2018, 10:13 AM #3
    sdean
    sdean is offline
    Registered User
    Join Date
    03-22-2018
    Location
    Castleford, England
    MS-Off Ver
    10
    Posts
    15

    Re: Adding £5 to a cell's formula, based on a dropdown result in another tab.

    yes or no is in B7 depending on what you select from this dropdown. The dropdown is populated by cells on another tab however.
    Reply With QuoteRegister To Reply
  4. 03-22-2018, 10:21 AM #4
    mjr veverka
    mjr veverka is offline
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Adding £5 to a cell's formula, based on a dropdown result in another tab.

    Ok, but this drop-down list, is it from Data tab => Data Tools group => Data Validation or is it something else ?
    Last edited by mjr veverka; 03-22-2018 at 10:24 AM.
    Reply With QuoteRegister To Reply
  5. 03-22-2018, 10:23 AM #5
    sdean
    sdean is offline
    Registered User
    Join Date
    03-22-2018
    Location
    Castleford, England
    MS-Off Ver
    10
    Posts
    15

    Re: Adding £5 to a cell's formula, based on a dropdown result in another tab.

    Yes, data validation, list, source: ='Foam Thickness'!$D$2:$D$3
    Reply With QuoteRegister To Reply
  6. 03-22-2018, 10:33 AM #6
    finalazy
    finalazy is offline
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    192

    Re: Adding £5 to a cell's formula, based on a dropdown result in another tab.

    Maybe
    =IF(Details!B7="Yes",(B10*F3+5),(B10*F3)) in your B12?
    Reply With QuoteRegister To Reply
  7. 03-22-2018, 10:40 AM #7
    davsth
    davsth is offline
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,210

    Re: Adding £5 to a cell's formula, based on a dropdown result in another tab.

    or
    =IF(Details!B7="Yes",5,0) + B10*F3
    Reply With QuoteRegister To Reply
  8. 03-28-2018, 04:26 AM #8
    sdean
    sdean is offline
    Registered User
    Join Date
    03-22-2018
    Location
    Castleford, England
    MS-Off Ver
    10
    Posts
    15

    Re: Adding £5 to a cell's formula, based on a dropdown result in another tab.

    Thanks, worked a treat!
    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] Formula that will result the cell blank based on adjacent cell
    By LShepherd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-20-2016, 01:04 PM
  2. Adding a value to a cell based on text chosen from a dropdown?
    By TrevP in forum Excel General
    Replies: 4
    Last Post: 07-25-2014, 08:36 PM
  3. Display result dynamically & automatically based on dropdown
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2013, 02:07 AM
  4. [SOLVED] Conditional format a cell based on a result of a formula in another cell
    By Taiter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-20-2013, 04:45 PM
  5. [SOLVED] Conditional format a cell based on a result of a formula in another cell
    By Taiter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-20-2013, 01:47 PM
  6. Adding multiple cells based on the result of a data validation cell
    By ronrona96 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-20-2013, 12:19 AM
  7. Adding a comment box based on a formula result
    By Drake2300 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2012, 05:21 PM

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