Hello Excel users.
I’d like to use an If function but for multiple conditions
Example
If (month (a1) = ( 3 ; 6 ; 9 ; 12); value if true; value if not true).
The idea is to pick a precise value if the month is 3 , 6 , 9 , 12 and another value ( a kind of estimation) for the rest of the months.
Last edited by Sokol; 09-03-2013 at 04:02 AM.
Please try this.
=IF(OR(MONTH(A1)={3,6,9,12}),"True value","False value")
Please click 'Add reputation', if my answer helped you.
=IF(OR(A1=3;A1=6;A1=9;A1=12);true;false)
=ALS(OF( enz enz
When I say semicolon, u say comma!
Thank you guys... Problem solved.
Please mark the thread as solved (above first post) and consider adding reputation to those who helped you (lower left corner of a post)
Another way..
=IF(MOD(MONTH(A1),3)=0,"true value","false value")
Life's a spreadsheet, Excel!
Say thanks, Click *
Sorry , but how can I mark it as a "solved " ???
Oh.. Found it.;..
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks