+ Reply to Thread
Results 1 to 2 of 2

Excel math equation

  1. #1
    Registered User
    Join Date
    03-15-2021
    Location
    New York
    MS-Off Ver
    2019
    Posts
    1

    Question Excel math equation

    I need some help with the equation - I have tried several times and unable to figure it out.

    In cells H2:H9, calculate the value of the adjusted salary package for each position over a two-year period, including any one-time bonus. The bonus does not need to be adjusted for location because the employee plans to use the bonus toward a vacation. Assume that the employee will receive a 2.5% raise after the first year of employment in the new position. Make sure that cells H2:H9 are formatted as Currency with two decimal places. Hint: The two-year package should consist of the adjusted salary in year one, the adjusted salary in year two (which is 2.5% higher than the adjusted salary in year one), and the one-time bonus in year one. Check Figure: Cell H5 = $88,674.69
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,259

    Re: Excel math equation

    In F2:
    =C2/D2-E2*12

    In H2:
    =F2*(1+2,5%)+F2+G2

    Copy down.

    Good luck!

+ 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. [SOLVED] Convert math equation into excel??
    By Dotreena in forum Excel General
    Replies: 15
    Last Post: 07-03-2019, 09:03 AM
  2. math equation in excel
    By ammartino44 in forum Excel General
    Replies: 6
    Last Post: 03-19-2014, 08:54 PM
  3. Help with math equation in Excell
    By savagera in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2013, 05:18 PM
  4. Converting a Math equation into an Excel formula
    By turnergraphics in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2011, 02:06 PM
  5. math equation help please
    By -Brian-H- in forum Excel General
    Replies: 1
    Last Post: 09-22-2006, 05:22 PM
  6. [SOLVED] Math involved. Excel speed optimization question. UDF vs. longer excel equation
    By Abe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2006, 10:20 AM
  7. Replies: 3
    Last Post: 02-16-2006, 07:00 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