+ Reply to Thread
Results 1 to 3 of 3

IF Statement containing words instead of numbers .

  1. #1
    Registered User
    Join Date
    02-09-2012
    Location
    Brisbane,Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    IF Statement containing words instead of numbers .

    Hi guys ,

    i am trying to get a IF statement to work with the following.

    i have a drop down list box with two different sections in them

    BED0005
    BED0009


    basically they way i want it to work is
    if the user selected the BED0005 it would deduct 21mm and if the user selected BED0009
    it would deduct 27mm

    so the problem is what kind of IF statement would i need to make this work .

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: IF Statement containing words instead of numbers .

    Deduct from what? Which cell is the drop-down in?

    Something like this:

    =IF(B1="BED0005",A1-21,IF(B1="BED0009",A1-27,""))

    where I have assumed the drop-down is in B1 and A1 contains the value that you want to subtract from.

    Hope this helps.

    Pete

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: IF Statement containing words instead of numbers .

    another one is

    =A1-IF(B1="",0,IF(B1="BED0005",2,1))
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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