+ Reply to Thread
Results 1 to 2 of 2

Formula where we can enter an amount and then calculate a cost

Hybrid View

  1. #1
    Registered User
    Join Date
    02-10-2023
    Location
    London, england
    MS-Off Ver
    2017
    Posts
    1

    Post Formula where we can enter an amount and then calculate a cost

    Can you help me to make a formula where we can enter a 'coverage amount' and then calculate a 'premium cost'?

    I was able to make a trendline here on this graph if we have a "coverage" field that says 200,000, then we need a calculation that spits out ~1000 or whatever the premium would be based on that trend line does that make sense?
    I can make the equation, but I do not know how to turn it into a formula where X is the coverage amount...
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Formula where we can enter an amount and then calculate a cost

    Your file appears to be corrupted. I decided against getting Excel to attempt a repair.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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. Formula to calculate cost and price
    By dandi10 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2022, 05:18 AM
  2. Replies: 3
    Last Post: 08-27-2021, 10:28 AM
  3. Replies: 15
    Last Post: 07-19-2019, 07:04 AM
  4. Formula to calculate Amount Paid and Amount Past Due
    By TinaAlldredge in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2016, 09:19 AM
  5. [SOLVED] Calculate cost per month inlcuding cost of former months
    By keis386 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2015, 11:17 AM
  6. [SOLVED] Formula to calculate a cost per day until total
    By Reno Nex in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2014, 11:16 AM
  7. Cost Driver calculation - Looking for formula/macro to calculate manpower cost alloca
    By Swastik Banerje in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2009, 11:18 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1