Using Office 2019.
I'm stumped and I just can't figure out how to use the "if" function along with a date (only the month).
In cell A1, I have the date (let's say December 31, 2022).
In cell B1, I want to return $100 if the contents of A1 is either March, June, September, December, if not, show "".
The part I can't figure out is how to use the "if" function with no regard for the "day and year", just use the month.
Any help would be appreciated.
Bruce
MONTH(A1) will return the month number
so
if A1 is march - you will get a 3
=IF(OR(MONTH(A1)=3,MONTH(A1)=6,MONTH(A1)=9,MONTH(A1)=12),100,"")
maybe able to use another way to show the qtr months
But thats an IF
Often, A sample sheet would help
The forum does allow for spreadsheets to be uploaded direct to the forum -
Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Here are the instructions, found at the top of the page again
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Last edited by etaf; 11-20-2022 at 07:34 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
This forum is the best....
The formula supplied by "etaf" worked perfectly.....=IF(OR(MONTH(A1)=3,MONTH(A1)=6,MONTH(A1)=9,MONTH(A1)=12),100,"")
Many thanks.
Bruce
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks