+ Reply to Thread
Results 1 to 17 of 17

If Function problem for newbie

  1. #1
    Registered User
    Join Date
    09-11-2007
    Posts
    22

    If Function problem for newbie

    I need to return a value of 10% or 20% depending on the value of a date in another cell to determine a deposit value depending if the date is is in Winter or Summer.

    For example the deposit will be 10% if a date falls in Winter determined by the MM value in an adjoinig date field cell.

    Therefore if the MM value from (DD-MM-YY) is 11-12-01-02-03 the deposit cell will reflect 10% and any other MM value will reflect 20% for Summer.

    Appreciate any help on this as this is way above my knowledge of functions/formulas.

    Thanks in advance

  2. #2
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: If Function problem for newbie

    Can u plz post a sample file
    Rgd
    RT
    If my answer(s) helped you, please add me reputation by click on *

  3. #3
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: If Function problem for newbie

    Hi

    Assuming that you have a date in A1 and a number in E1, then try this formula in another cell.

    =IF(OR(MONTH(A1)=11,MONTH(A1)=12,MONTH(A1)=1,MONTH(A1)=2,MONTH(A1)=3),E1*10%;E1*20%)
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Registered User
    Join Date
    09-11-2007
    Posts
    22

    Re: If Function problem for newbie

    Added sample file
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,964

    Re: If Function problem for newbie

    =IF(OR(MONTH(B4)>10;MONTH(B4)<4);0,1;0,2)
    With a celformaat from 'percentage'
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  6. #6
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: If Function problem for newbie

    AS PER YOUR ATTACHMENT TRY THIS

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Format cell to Percentage

  7. #7
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: If Function problem for newbie

    Sorry the correct formula is

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    08-07-2013
    Location
    Amsterdam
    MS-Off Ver
    Office 2010; Openoffice
    Posts
    9

    Re: If Function problem for newbie

    Quote Originally Posted by popipipo View Post
    =IF(OR(MONTH(B4)>10;MONTH(B4)<4);0,1;0,2)
    With a celformaat from 'percentage'
    That's what I came up with. But it needs an extra 'OR', right?

    =IF(OR(MONTH(B4)>10)*OR(MONTH(B4)<4);0,1;0,2)

  9. #9
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: If Function problem for newbie

    Quote Originally Posted by Alexej View Post
    That's what I came up with. But it needs an extra 'OR', right?

    =IF(OR(MONTH(B4)>10)*OR(MONTH(B4)<4);0,1;0,2)
    No. popipipo's formula works great.

  10. #10
    Registered User
    Join Date
    09-11-2007
    Posts
    22

    Re: If Function problem for newbie

    I am still getting an error when using the following

    =IF(OR(MONTH(B4)>10;MONTH(B4)<4);0,1;0,2)

    Not sure why to be honest

  11. #11
    Registered User
    Join Date
    08-07-2013
    Location
    Amsterdam
    MS-Off Ver
    Office 2010; Openoffice
    Posts
    9

    Re: If Function problem for newbie

    Quote Originally Posted by gico1972 View Post
    I am still getting an error when using the following

    =IF(OR(MONTH(B4)>10;MONTH(B4)<4);0,1;0,2)

    Not sure why to be honest
    Same here, that's why I thought it needed the extra OR...

  12. #12
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: If Function problem for newbie

    Quote Originally Posted by Alexej View Post
    Same here, that's why I thought it needed the extra OR...
    Quote Originally Posted by popipipo View Post
    =IF(OR(MONTH(B4)>10;MONTH(B4)<4);0,1;0,2)
    With a celformaat from 'percentage'
    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  13. #13
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: If Function problem for newbie

    Hi

    ..I am still getting an error when using the following

    =IF(OR(MONTH(B4)>10;MONTH(B4)<4);0,1;0,2)

    Not sure why to be honest
    Take a look to the example pls.
    Attached Files Attached Files

  14. #14
    Registered User
    Join Date
    09-11-2007
    Posts
    22

    Re: If Function problem for newbie

    Perfect!! Now that works. Thanks

  15. #15
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: If Function problem for newbie

    Quote Originally Posted by Fotis1991 View Post
    Hi



    Take a look to the example pls.

    Edit: And for better understanding of all of you,popipipo in Holland(as i in Greece) use semi colns as separators(according to our local settings) and not comma. So if you change all semi colons to comma, fornula works fine.

  16. #16
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: If Function problem for newbie

    Quote Originally Posted by gico1972 View Post
    Perfect!! Now that works. Thanks


    You are welcome(from all of us) and thanks for the feed back.

    As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

    Also, as an old member(but with few posts) of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  17. #17
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,964

    Re: If Function problem for newbie

    popipipo in Holland(as i in Greece) use semi colns as separators
    I usually change it.
    Unfortunately I forgot this time

+ 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. Newbie problem
    By catcher24 in forum Excel General
    Replies: 1
    Last Post: 02-17-2007, 02:46 PM
  2. Newbie with problem (duh!)
    By opopanax666 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-06-2006, 10:48 AM
  3. Newbie VBA Problem
    By FCC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2006, 12:50 PM
  4. Newbie problem :(
    By Liosan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-15-2005, 10:05 AM
  5. Newbie Problem
    By BuddyB in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2005, 10:21 PM

Tags for this Thread

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.08511 seconds
  • Memory Usage 9,360KB
  • Queries Executed 16 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (9)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (17)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_attachment
  • (17)postbit_legacy
  • (17)postbit_onlinestatus
  • (17)postbit_wrapper
  • (4)showthread_bookmarksite
  • (5)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (50):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1