Jump to content

Search the Community

Showing results for tags 'excel function'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 3 results

  1. Hello all, I have a current Excel Spreadsheet and new to Caspio I am creating a formula in my data sheet, however the existing Excel one I copy over is not functioning. Let me explain here: The current Excel Formula is: =ROUND(((DAYS360(J7;$P$2))/360);1) where J7 is a date of birth, $P$2 is the current date (today) and the answer should read the person's age example 59,2. How would I convert this to Caspio? Regards, Mark (Johannesburg, South Africa)
  2. Hi everyone, I would like to implement XIRR function from Excel in Caspio. Can somebody give me a direction on how to achieve this? Thanks, vitalikssssss
  3. I need to to perform functions that will calculate payments based on a loan amount, interest rate and term. This is an easy function in excel: =(MAX(Payments!M3:M32))/12 BUT, can I get some suggestions as to how to do this in Caspio? Secondly, I'd like to get an amoritzation schedule showing payments and declining balance over a period of time such as 1 year, 5 years, etc. Has anyone done this in Caspio?
  • Create New...