right() not working

  1. T

    Excel Right Function Dilemma

    Hi all, I have a confusion with using RIGHT function. I need to create a complicated formula that depending on two digits after comma. I’ve used RIGHT function to do it but the step that you can see below, the result seems like isn’t true. I'm sharing formula with the sample values(not cellIDs...
    • trndlr
    • Thread
    • right formula right function right funtion right() right() not working
    • Replies: 3
    • Forum: Excel Questions
  2. C

    IF Formula not recognizing conditions (no errors just wrong answer)

    Hello! My goal is to filter through some three/four digit IDs. Any three digit ones need to be ignored. Any that end with a 1,2,3, or 9 need special attention. Those numbers need to drop the last digit. Sample: 2309 needs to become 230 I have a nested IF statement that isn't working...
  3. K

    Right() not working

    I am trying to extract a number from the text string "10~13" located at Col A, Row 3 by using the formula RIGHT(A3,2) located in B3. I get the result in B3 of "13". But when I test it with the formula IF(B3=13,"Y","N") located in C3, I get the result "N". I have tested the length of B3 with...
  4. M

    Excel Formula Help

    Hello...I have 3 formulas that I am having trouble getting to do what I want that have been in use for quite some time. Any quick assistance would be very much appreciated! 1- I am trying to get the last populated cell value in a series of non consecutive cells in a row to return. 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