help on an if formula

  1. A

    HELP with this formula

    hi, I have these tournament with my friends and made a formula but for some reason is not working i wanted to know why not i want to be able to put in the score in of the match we had an automatic change the amount of game played, if lost or won and even the goals we made...
  2. B

    Help with an IF formula

    I have a spreadsheet of approximately 20,000 rows and 50 columns. In Column C I have a list of SKUs that look like the following. 10001 10001B1 10001B2 100001B3 100002 100003 100003B1 100003B2 100003B3 100003B4 and so on. The B1,B2, etc are for additional boxes. The highest it goes up to is...
  3. R

    Multiple IF, AND & OR Formula - Help Needed.

    I'm struggling to write a working formula that contains all the arguments below to return the correct result. IF D3 = "4" OR "8" AND G3 = "1" then "8DM11" IF D3 = "4" OR "8" AND G3 = "2" then "8DM21" IF D3 = "A" AND G3 = "1" then "8DM11" IF D3 = "A" AND G3 = "2" then "10NM1" Any help on this...
  4. P

    IF Formula (Or maybe something else...)

    http://www.box.net/shared/0ebhd83tg6 Hi Guys So heres what I want to do. I need to link up the PO's and part values on the Stock out and relevant values to the corresponding PO's on the Consignment stock sheet. (It makes sense when you look at the workbook) For example Column B on the Stock...
  5. P

    Column Referencing in Excel 2003

    Hi Everyone. Ok so I need to know how do I reference a column in a formula, but NOT by its letter E, F, D etc. But by its text or number in Row 1. My formula I've got needs to find a column with a particular text in, then take all values related with that column. Now I know you will say why...
  6. G

    Need help on an IF formula

    If it has TXEQ in column A then need to add 4.00 to column C so answer reflects total with extra 4. in it… A B C Answer current formula C30 96,300.00 101.932 $1,860.52 =(C1-100)*B1/100 C15TXEQ 120,600.00 96.087 $(4,719.08) F30...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top