if formula help problem

  1. L

    Using the 'If' function to match two columns with the same first three letters of text

    Hi all, I just want to perform a quick quality check on some of my data and I am after a bit of help to make the proper formula as I keep getting too fewer arguments with my formula. <tbody> A B C 1 Food Code Food Matches? 2 MARTOA Marmite Yes 3 JAMTOA Jam Yes 4 HONTOA Marmite No 5...
  2. K

    IF Function Formula assistance required - THANK YOU

    Hi All, I know what I am wanting to do but I can't find the right written expression to generate the results. What I wanting is column J to do the following: If F2>1 then D2 – F2 or if F2 is blank D2+E2*H2 Sample <!--StartFragment--> <colgroup><col width="65" span="10"...
    • KALAF
    • Thread
    • if formula excel help if formula help problem if formula problem
    • Replies: 1
    • Forum: Excel Questions
  3. M

    IF formula to return a value but if no value perform a calculation

    Hi! I have been racking my brain trying to find a formula that will do the following: IF I3 states "Not Recv'd" to return "Not Recv'd" but if no text exists in cell I3 then perform this formula IF(J3>=I3,"1","0"). Can anyone help me put these together? Thanks! :confused::confused:
  4. B

    if three values true then OK else missing value

    I have scenerio in excel Job Nature, in Column T which have values (W), (F) (M) Days to check in Column S which have values "No. of Days" & Paid W/Card in Column N which have values True , False The Thing I want to check is, if Job Nature is (W) and No. of Days is <= 365 and the W/Card is Ture...
    • Banjara
    • Thread
    • checking if formula help problem multiple conditions
    • Replies: 6
    • Forum: Excel Questions
  5. S

    IF Formula Help Please

    Hey Guys I am trying to perform an if formula on a cell but am running into a few problems. There a three options with the cell, one is that it is blank and has no information, one is that it will contain the number 1, and one is that it will contain the number 2. What I would like to happen is...

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