higher

  1. C

    Advanced Filter

    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...
  2. R

    If statement

    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...
  3. S

    FIND next or higher next value in a table range

    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...
  4. R

    implementation of NORM.INV

    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...
  5. J

    Highlight Cells Refering To Row Greater Than

    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
  6. bill351

    IF and LOOKLEFT and LOOKRIGHT functions

    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...
  7. A

    Using the number that has the higher value

    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...
  8. R

    Higher, median, & lower

    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...
  9. M

    Dont show content if cell has a number higher than 1

    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
  10. S

    Forrmular for WBC white blood cell counting two column numbers

    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.
  11. 4

    Dependent Drop Down List

    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...
  12. S

    Custom Number Formatting

    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!
  13. K

    Problem with VALUE()

    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...
  14. W

    If then function analyzing changes in quantities and prices between data sets

    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...
  15. D

    Random percentages

    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...
  16. O

    Convert cell formula to VBA

    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...
  17. J

    Ranking based on 3 criteria

    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...
  18. D

    help with a formulafor an excell newbie

    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...
  19. R

    Compare values between rows

    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...
  20. N

    Display ASCII Character Codes higher than 255 in appropriate script

    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. "&#1332 ;" - without the space in between the "2" and the ";")...

We've detected that you are using an adblocker.

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.
Go back
Back
Top