+ Reply to Thread
Results 1 to 14 of 14

Help with if than

  1. #1
    Registered User
    Join Date
    04-18-2021
    Location
    New york
    MS-Off Ver
    2016
    Posts
    7

    Help with if than

    I need formula for " if a3 is sunday tues than smith . if a3 is monday wednesday friday saturday than walker"
    Thank you

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Help with if than

    =IF(OR(WEEKDAY(A3)=1,WEEKDAY(A3)=3),"smith","walker")
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    04-18-2021
    Location
    New york
    MS-Off Ver
    2016
    Posts
    7
    Quote Originally Posted by protonLeah View Post
    =IF(OR(WEEKDAY(A3)=1,WEEKDAY(A3)=3),"smith","walker")
    Thank you does not work. What I want to do is automatically put name in another cell lets say z10. So let say the a3 says mon or tue smith name enterz in z10 and if weds thus fri walker name popup in z10
    Last edited by bobeknr1; 04-18-2021 at 08:56 PM.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Help with if than

    I think what Ben gave you would work if you have dates in col A formatted as days of the week.
    assuming you simply have days in col A such as Sunday etc, then maybe this...
    =IF(OR(A3="Sunday",A3="Tuesday"),"smith",IF(A3="Thursday","","walker"))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Help with if than

    The formula goes where ever you want the results.
    You didn't say what's in A3. I assumed it was a date. That's why you should always attach a sample file to preclude guesswork.

  6. #6
    Registered User
    Join Date
    04-18-2021
    Location
    New york
    MS-Off Ver
    2016
    Posts
    7
    Quote Originally Posted by Sam Capricci View Post
    I think what Ben gave you would work if you have dates in col A formatted as days of the week.
    assuming you simply have days in col A such as Sunday etc, then maybe this...
    =IF(OR(A3="Sunday",A3="Tuesday"),"smith",IF(A3="Thursday","","walker"))
    Everything works exept when i enter thursday it says false
    =IF(OR(S6="Sunday",S6="Monday",S6="Tuesday",S6="Wednesday",S6="Saturday"),"smith",IF(S6="Thursday",S6="Friday""","walker")

  7. #7
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Help with if than

    2 options:

    =IF(OR(S6="Sunday",S6="Monday",S6="Tuesday",S6="Wednesday",S6="Saturday"),"smith","walker")

    =IF(OR(S6="Thursday",S6="Friday"),"walker","smith")
    Quang PT

  8. #8
    Registered User
    Join Date
    04-18-2021
    Location
    New york
    MS-Off Ver
    2016
    Posts
    7

    Re: Help with if than

    Works thank you Guys for help

  9. #9
    Registered User
    Join Date
    04-18-2021
    Location
    New york
    MS-Off Ver
    2016
    Posts
    7
    Quote Originally Posted by bebo021999 View Post
    2 options:

    =IF(OR(S6="Sunday",S6="Monday",S6="Tuesday",S6="Wednesday",S6="Saturday"),"smith","walker")

    =IF(OR(S6="Thursday",S6="Friday"),"walker","smith")

    One more question. If K6 is date and s6 is day of the week and in cell s6 there is =k6 so day of the week changes automatically but for reason formula above does not changes names .Have to manualy enter name of day week DO you know how to fix it
    Last edited by bobeknr1; 04-19-2021 at 12:39 AM.

  10. #10
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,001

    Re: Help with if than

    Look at post #3.

  11. #11
    Registered User
    Join Date
    04-18-2021
    Location
    New york
    MS-Off Ver
    2016
    Posts
    7
    Quote Originally Posted by JohnTopley View Post
    Look at post #3.
    But when i enter date lets say 4/19/21 weekday name changes to monday but now the name does not change. If i enter enter manualy monday the change . So could you help me with that

  12. #12
    Registered User
    Join Date
    04-18-2021
    Location
    New york
    MS-Off Ver
    2016
    Posts
    7
    Quote Originally Posted by bobeknr1 View Post
    But when i enter date lets say 4/19/21 weekday name changes to monday but now the name does not change. If i enter enter manualy monday the change . So could you help me with that
    I think i get it use =IF(OR(WEEKDAY(A3)=1,WEEKDAY(A3)=3),"smith","walker")
    On a date not name of the day right?

  13. #13
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,001

    Re: Help with if than

    Yes check week day as a number not as a name (text)..

  14. #14
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Help with if than

    It would help immensely if you attached a workbook so we can see exactly what you are working with and give a solution. Attach a workbook as described in the yellow banner at the top of the page.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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