1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Simple Minus % - Can excel do it?

Discussion in 'Business Applications' started by tzme, Aug 21, 2014.

Thread Status:
Not open for further replies.
Advertisement
  1. tzme

    tzme Thread Starter

    Joined:
    Aug 14, 2014
    Messages:
    3
    I have an average on the product's i sell, ill loose 20% percent of the items. for an example: if i order 100 dolls 20 of it will not sell...

    As much as i tried and as many people i asked i couldn't find a way to make an excel sheet to tell me the simple calculation of B2 should be 20% less than A2

    I thought ill be able to find someone out there to help me.

    With great appreciation.

    Tzme
     
  2. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    60,891
    First Name:
    Chuck
    Put this in B2
    Code:
    =A2*(1-20%)
     
  3. CodeLexicon

    CodeLexicon

    Joined:
    Oct 15, 2013
    Messages:
    503
  4. tzme

    tzme Thread Starter

    Joined:
    Aug 14, 2014
    Messages:
    3
    Thanks so much!!!
     
  5. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    60,891
    First Name:
    Chuck
    You're welcome.
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1132019

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice