Hi folks, used this forum for ages but had to register as I'm not sure on how to articulate what I need in order to search for it.
So I have a master project tracker with thousands of rows. When I get an update, they can be in 50's or higher. They also come in via excel. So is there a way I...
Hi,
I am using the If and then statement. =IF((D6+D7-C8)>=C8,0,(D6+D7-C8)). But when the amounts are less than C8 it should be giving me a zero but it gives me a negative #. When I flip the greater, less than sign it gives me the Zero, but then it doesn't calculate correctly if my D6 and D7 are...
hi all
this is my peculiar problem
please help me out
i have to lookup for TWO values and return the equal value or next higher value in the table
IF MY VALUES ARE 3 AND 450 the return value should be 500
ALSO MY VALUES ARE 7 AND 800 the return value should be 800
plasse help me...
Hi, could anybody please advise on the background calculation used to implement the NORM.INV function in Excel?
I need to hand code it in Java. I have managed to convert some other statistical functions this way but am finding it hard to get info on this one.
I have done some searching but...
Hi guys,
Id like to be able to highlight or otherwise see any cells with a formula with link to a row higher than lets say 240
Any thoughts would be most welcome!
Thanks!
Rob
Hey Guys n Girls I am trying to automate a data spreadsheet with the above functions.
What I have is spreadsheet to record Higher Duties and Column A is Payroll Number Column B is the staff name via a drop down box and Column C is their current pay increment so I have started on a formula...
Hi all,
I have been playing around with some formulas but can't seem to find the correct one (Probably having a blonde moment)
We have the following:
Volume: 2.27
Actual weight: 300kg
Volumetric Weight (Volume x 167): 379.09
Chargeable weight (The higher number between actual weight and...
Hi
Need some help on this
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody>
April 11, 2018
March 11, 2018
February 11, 2018
#E67C73[/URL] , align: center"]$238,912.53
#57BB8A[/URL] , align: center"]$345,568.02
#FFD666[/URL] , align...
Hello,
I have a formula that is working fine: =D9/0,6
But I want this formula to display nothing IF the number of another cell is higher than 1.
Can anyone help me?
Jon
I have a problem about my wbc counting. A1 3000 b2 5000 c1 2500 d1 show Lower if less than a1 Greater if higher than b2 and normal for between 3000-5000 by using number to check standard between a1-b2. Thanks you.
Hi Everyone,
So I have been having an issue with figuring out the best way to display some data after some user input through a drop down list. To give you an idea of what I want I currently have in mind as an end result, this is what I would like it to look like in a word document or excel...
What I need to do is have a specific column show as a percentage if it will be 100% or less, or change into currency if higher than that. I'm not sure if it is possible, however, it's worth a try!
Good Day
I have a data feed from a supplier which I imported into excel.
I want to take their prices from the "Price" column and use VALUE
on it because it seems to be a string.
Now, VALUE works fine on all values except when the value in "Price"
is higher than 999.99 So basically I get the...
Hello, thank you for considering helping me with my problem.
I would like and appreciate a function that does the following for my work.
A function that enters the following values into a cell if the cells it is referencing meets a criteria.
1 if C2 is blank or zero
2 if C2 is 9 or more less...
Hi,
I need a bit of help for a work project i'm currently looking in to.
I need to return a random value that is between 10-25% higher than a specified value. For example, I have a figure of £314.25 and, in the next cell, I need to get a figure that is randomly between 10-25% higher.
I know...
Hello, is there a hero to help me convert a cell formula to VBA code with a custom function?
The cell formula takes 2 selected values and calculates the difference between them, and then shows the result as "xx % difference".
The difference is always calculated in regards to the higher value...
Hi everyone. I've searched through the forums and haven't found exactly what I'm looking for just yet so I thought I'd ask.
How could I rank projects based on items, age, city (city is given a number) for example
A B C
5 73 Portland 13
2...
Hi
I'm new to excel & teaching myself.
I have a simple expenses spread sheet where I have 2 columns but need to use which ever column total is higher in another cells sum.
example if column b total is higher than column a then I want to use column b total in my sum elsewhere in the sheet
any...
Hi,
Im looking to compare the price of items in a spreadsheet.
In the example below, Im looking for a function for the Higher or Lower column that compares Item ID "1" with itself and identifies which is the higher and lower price of the two.
<tbody>
Item ID
Price
Higher or Lower
1...
Hi there - I've been trying to get Excel to display high-value ASCII codes but am failing so far...
Basically, I've extracted a load of data from an SQL database, and a large amount of the data is appearing as character codes (e.g. "Դ ;" - without the space in between the "2" and the ";")...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.