Results 1 to 7 of 7

Picking up a cell as a negative in a formula

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    85

    Picking up a cell as a negative in a formula

    Hello I was wondering if any one could help. Im trying to get a formula to work. I have two columns one with the figure 45 and other with 1.62%

    Im trying to get this sum to work 100-45 x (1.62%) - 100 = (45.89)

    I know this is simple but I cant get a formula to work the same way as the sum.The problem im having is with column with the percentage in. I need to pick it up as a minus but cant seem to do this.
    Last edited by gandyling; 10-05-2011 at 02:46 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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