formula results

  1. L

    Use of =PROPER in Excel workbook

    I just figured out that this existed (=PROPER to change fields that are capitalized, so that the first letter of each word is capitalized), yay! But am having the dumbest issue with it: my workbook displays the formula, not the result. :confused:
  2. R

    Formula to establish the sequence number within a string?

    Hello can somebody help me with this part of my formula, I thought it was just a simple IF(Find(Right)) formula but it returns a #Value!!! =IF(FIND(">",(RIGHT(G7,2)),1)>0,RIGHT(G7,1),IF(FIND(">",RIGHT(G7,3),1)>0,RIGHT(G7,2),RIGHT(G7,3))) G7 contains a manually entered sequence of numbers...
  3. M

    2-way unit conversion

    Hi, I'm making a unit conversion table in Excel.. figured out the CONVERT fomula; however, i'd like to have a formula that works 2 ways. For example: This will reduce the cells needed for this operation from 4 to 2-3. Please let me know! Thanks ;)
  4. G

    Part of formula result formating

    I would like to format part of cell, but in that cell is a formula... e.g. ="sum is: "&SUM(A1:A10) Result should have format like... sum is: 10 Any idea, how to do this? Thanks a lot.
  5. T

    Find and replace based on formula result

    Hey all! I'm looking for a bit of code that would seek out a specific value that's displayed as a result of a formula and, once found, clear those cells. For example, my formula is...
  6. B

    Formulas Not Accepted

    I have a file with a worksheet that doesn't accept formulas even that begin with an equal sign and have accurate syntax. Rather than return a value, the cell contains the formula syntax with the equal sign. This problem can be isolated to 1 worksheet in the file. Any ideas what causes this...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...