+ Reply to Thread
Results 1 to 17 of 17

If Function problem for newbie

  1. 08-07-2013, 05:34 AM #1
    gico1972
    gico1972 is offline
    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
    Reply With QuoteRegister To Reply
  2. 08-07-2013, 05:38 AM #2
    rajeshturaha
    rajeshturaha is offline
    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 *
    Reply With QuoteRegister To Reply
  3. 08-07-2013, 05:41 AM #3
    Fotis1991
    Fotis1991 is offline
    Forum Expert 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.
    Reply With QuoteRegister To Reply
  4. 08-07-2013, 05:52 AM #4
    gico1972
    gico1972 is offline
    Registered User
    Join Date
    09-11-2007
    Posts
    22

    Re: If Function problem for newbie

    Added sample file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 08-07-2013, 05:58 AM #5
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,289

    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
    Reply With QuoteRegister To Reply
  6. 08-07-2013, 06:04 AM #6
    rajeshturaha
    rajeshturaha is offline
    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
    Reply With QuoteRegister To Reply
  7. 08-07-2013, 06:05 AM #7
    rajeshturaha
    rajeshturaha is offline
    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.
    Reply With QuoteRegister To Reply
  8. 08-07-2013, 06:14 AM #8
    Alexej
    Alexej is offline
    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)
    Reply With QuoteRegister To Reply
  9. 08-07-2013, 06:18 AM #9
    Fotis1991
    Fotis1991 is offline
    Forum Expert 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.
    Reply With QuoteRegister To Reply
  10. 08-07-2013, 06:44 AM #10
    gico1972
    gico1972 is offline
    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
    Reply With QuoteRegister To Reply
  11. 08-07-2013, 06:48 AM #11
    Alexej
    Alexej is offline
    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...
    Reply With QuoteRegister To Reply
  12. 08-07-2013, 06:59 AM #12
    rajeshturaha
    rajeshturaha is offline
    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.
    Reply With QuoteRegister To Reply
  13. 08-07-2013, 07:13 AM #13
    Fotis1991
    Fotis1991 is offline
    Forum Expert 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
    Reply With QuoteRegister To Reply
  14. 08-07-2013, 07:14 AM #14
    gico1972
    gico1972 is offline
    Registered User
    Join Date
    09-11-2007
    Posts
    22

    Re: If Function problem for newbie

    Perfect!! Now that works. Thanks
    Reply With QuoteRegister To Reply
  15. 08-07-2013, 07:16 AM #15
    Fotis1991
    Fotis1991 is offline
    Forum Expert 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.
    Reply With QuoteRegister To Reply
  16. 08-07-2013, 07:22 AM #16
    Fotis1991
    Fotis1991 is offline
    Forum Expert 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.
    Reply With QuoteRegister To Reply
  17. 08-09-2013, 01:37 PM #17
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,289

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1