+ Reply to Thread
Results 1 to 3 of 3

how to assign certain number in one cell based on month value in another cell ?

  1. #1
    Registered User
    Join Date
    10-09-2020
    Location
    Edmonton,Canada
    MS-Off Ver
    Office 2003
    Posts
    9

    how to assign certain number in one cell based on month value in another cell ?

    Hi,
    I want to assign a number in one cell based on month value in another cell e.g. if date in cell B20 is 28/04/2013 (28 th April 2013) means month is 4. If month = 4 then Cell value in F20 should contain 4 ELSE it should contain 5. I tried this formula in cell E20 like....,
    =IF((MONTH(B20))=4,F20=4,F20=5)

    but instead of giving desired result, it appears word FALSE in cell E20, why and how to resolve ?
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,842

    Re: how to assign certain number in one cell based on month value in another cell ?

    Try this in F20:
    =IF(MONTH(B20)=4,4,5)

  3. #3
    Registered User
    Join Date
    10-09-2020
    Location
    Edmonton,Canada
    MS-Off Ver
    Office 2003
    Posts
    9

    Re: how to assign certain number in one cell based on month value in another cell ?

    thanks Gregb11 it worked !! although not in Cell E20, but I can manipulate from F20

+ 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. Assign a value to a cell based on a portion of the content of another cell
    By smatchymo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-08-2015, 02:56 PM
  2. [SOLVED] Forumula to assign a number to an adjacent cell based on value
    By HDeuce in forum Excel General
    Replies: 2
    Last Post: 11-21-2014, 12:23 PM
  3. Create Auto-Calculating Cell and Assign Cell Values Based on a Macro
    By Titanium Fox in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2013, 12:00 AM
  4. [SOLVED] Novice trying to work how assign value in a cell based on another cell
    By jcartworx in forum Excel General
    Replies: 7
    Last Post: 08-30-2012, 01:30 PM
  5. Replies: 3
    Last Post: 08-13-2012, 01:03 AM
  6. Replies: 2
    Last Post: 07-24-2012, 11:47 AM
  7. Replies: 7
    Last Post: 12-18-2008, 07:34 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1