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: Need Excel Help

Discussion in 'Business Applications' started by jvic, Apr 18, 2015.

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

    jvic Thread Starter

    Joined:
    Apr 17, 2004
    Messages:
    363
    First Name:
    John
    Trying to work out formula. Attached sheet will explain.
     

    Attached Files:

  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Since yu converted your cells to text (because you want to have 00000, you have to check on the value of the cell, NOT the contents

    The forvula should look like this:

    Code:
    =IF(VALUE(D5)<>0,(D5-B5)*0.15,0)
    
    Good-night
     

    Attached Files:

  3. jvic

    jvic Thread Starter

    Joined:
    Apr 17, 2004
    Messages:
    363
    First Name:
    John
    Worked perfect Thank you very much
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Glad to have been able to help :)

    A suggestion, if you need numeric values to display leading zero's you can do the following:

    Make sure the cell or cells are formatted as number.
    Right click and select Custom, in the filed eher it will probably show either 0,00 or just 0 typr in the number or 0 you want
    If you want six digits type 000000

    Now when you enter a value in that cell it will always display a total of six digits with the numer leading zeros.


    6 -> 000006
    12 -> 000012

    In the formula bar however you will only see 6 or 12.

    The advantage is that the all formulas will work and you do not neet to interpret them as value
     
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/1146822

  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