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.
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.
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.
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by popipipo
Bookmarks