if & len

  1. A

    len & if function

    Hi Guys, I have a question about excel. i would like to create a function with this criteria : when the wbs is GWV1P100275-01 until GWV1P100275-09 i would like to take in "I" cell the value GWV1P100275 , when the wbs is GWV1P100275-01-001 until GWV1P100275-01-009 i would like to take in "I'...
  2. J

    Using IF,AND + LEN

    So i have a cell with product codes inside of that. for example cell a1 contains data - 1x ddjed8cx7ee cell a2 contains data - 4x ddjeudaadi3 cell a3 contains data - 1x nddnadjnfke 1x ajo37danunau 4x aud73ndnnak and so on I am trying to find a formula that can A. return the value of 30...

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