Solved: Need Excel Help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

jvic

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

Attachments

Keebellah

Trusted Advisor
Joined
Mar 27, 2008
Messages
6,611
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
 

Attachments

jvic

Thread Starter
Joined
Apr 17, 2004
Messages
363
First Name
John
Worked perfect Thank you very much
 

Keebellah

Trusted Advisor
Joined
Mar 27, 2008
Messages
6,611
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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Top