+ Reply to Thread
Results 1 to 2 of 2

Adding two forumals to one cell

  1. #1
    Registered User
    Join Date
    04-27-2016
    Location
    wales
    MS-Off Ver
    2007
    Posts
    6

    Adding two forumals to one cell

    Hi Having problems, working two formulas into one cell
    Any help would be very much appreciated.

    EXAMPLE

    £450 Rent
    7% Fees @
    20% Vat on Fees


    £31.50 Fees
    £6.30 VAT
    £37.80 Total Fees

    £412.20 Net Figure

    What I would like to know is how do I do the formula in one cell to show the Vat and Fee minus the original sum received to end up with the NET figure
    Thank you in advance
    :-)

  2. #2
    Forum Contributor
    Join Date
    07-11-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    144

    Re: Adding two forumals to one cell

    Hi giffy,

    Please find the solution below

    put your rent on A1 cell

    Please Login or Register  to view this content.
    Ravikumar,

    * Please Add Reputation if solved.

+ 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. IF forumals, Autofill?
    By BREECHEEZ87 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-13-2015, 12:42 PM
  2. case sensitive forumals
    By bjbboats in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-14-2015, 04:39 AM
  3. Order of operations in excel forumals.
    By aem2879 in forum Excel General
    Replies: 2
    Last Post: 10-25-2014, 02:27 AM
  4. How to substitue variables in my function/forumals?
    By bankerguy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-23-2014, 06:23 PM
  5. Replies: 2
    Last Post: 06-05-2011, 09:46 PM
  6. Linking Forumals into One Cell
    By SportsScientist in forum Excel General
    Replies: 4
    Last Post: 06-18-2009, 11:45 AM
  7. Forumals Turning Off (ie., not working)?
    By Fattie in forum Excel General
    Replies: 1
    Last Post: 02-04-2007, 11:45 AM

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