Solved

COUPNCD Formula

Posted on 2014-04-01
5
260 Views
Last Modified: 2014-04-07
Hi I am using the below formula which works fine when the frequency is 1, 2 or 4 but, I have been asked if it's possible to include 12 which the formula does not work with. So my question is, is there a formula that will include a monthly frequency
in addition to Quarterly, Semi Annually and Annually

=COUPNCD(TODAY(),H7,G7,3)

Thanks
0
Comment
Question by:Jagwarman
  • 3
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
Jignesh Thar earned 500 total points
ID: 39968717
COUPNCD doesn't support monthly or semi-annually frequency.
0
 

Author Comment

by:Jagwarman
ID: 39968722
isn't 2 semi annually ?

so if COUPNCD doesn't support monthly is there a formula that does?
0
 
LVL 7

Expert Comment

by:Jignesh Thar
ID: 39968738
sorry..Yes 2 is semi-annually. I meant to say that COUPNCD doesn't support monthly (12) or bi-monthly (6).

Let me check if custom VBA can support this.
0
 

Author Comment

by:Jagwarman
ID: 39969055
ok tks
0
 

Author Closing Comment

by:Jagwarman
ID: 39982327
thanks for the answer even it was not what I wanted to hear
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question