+ Reply to Thread
Results 1 to 2 of 2

Formula needed to check my vat and net totals match my grand total and to show any differ

Hybrid View

  1. #1
    Registered User
    Join Date
    06-13-2016
    Location
    England
    MS-Off Ver
    2012
    Posts
    1

    Formula needed to check my vat and net totals match my grand total and to show any differ

    Hello everyone, I am a newbie to the forum and a newbie to Excel too so apologies in advance if I ask very silly questions!,

    I have a worksheet with three columns grand total, vat and net total. I need a formula that will show any discrepancies with my Vat and Net if they do not match my grand total figure.
    Is there a formula for this type of checking?
    Last edited by Sandpiper1809; 06-13-2016 at 04:06 PM. Reason: Not complying with rules

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,627

    Re: Struggling with formulas!,

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

+ 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. struggling to get 2 IF formulas to work in one cell
    By cab1979 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-07-2014, 11:18 AM
  2. Struggling with using IF and IF(AND) formulas
    By jbw1975 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2014, 05:56 PM
  3. [SOLVED] Struggling with Vlookups
    By DP17 in forum Excel General
    Replies: 11
    Last Post: 09-20-2012, 10:04 AM
  4. Struggling with IF
    By KClark in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2011, 04:37 AM
  5. struggling
    By Tomas mcD in forum Excel General
    Replies: 1
    Last Post: 03-07-2011, 08:25 AM
  6. [SOLVED] Struggling IF value
    By Rebecca in forum Excel General
    Replies: 5
    Last Post: 04-06-2006, 04:55 PM
  7. [SOLVED] Help, I'm Struggling!
    By Fybo in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-04-2005, 04:06 PM

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