Get instant live expert help on I need help with excel mid function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

hello..i need help in left right and mid function
Solved by A. H. in 16 mins
Can you re edit this formula for me =IFERROR(IF(LEN(MID("RHS",1,FIND("RHS",B4,1)))=1,LEFT(B4,3),MID("RHS",1,FIND("RHS",B4,1))),MID("LHS",1,FIND("LHS",B4,1)))
Solved by S. L. in 24 mins
I am trying to combine if statements if true then if this or this or this is true (if true) =IF(SEARCH("($",MID(T5,1,O5))>0 (then if either of these are true) IF(SEARCH("CASH",MID(T5,1,O5))>0,1 IF(SEARCH("PYMT",MID(T5,1,O5))>0,1 IF(SEARCH("PAYMENT",MID(T5,1,O5))>0,1
Solved by F. W. in 19 mins
This is regarding tab “TrueUp AddProd”. I need help with listing values for column S “Mid Term Fee”. For example: -If Column R = “Azure” then “Mid Term Fee” on column S = 0.00 AND -If Column R = “Mid Term Core”, “Mid Term Tier 2”, and “Mid Term Tier 1” = a VLOOKUP type rule Look at the “Agreement Number” in column A on “TrueUp AddProd” Tab – Look for the same “Agreement Number” in Column A on “Agreement Levels” tab. They should match. Then take the corresponding Mid Term Core or Mid Term Tier 2 or 1 ” value on columns L through N of “Agreement levels” tab and times it by “The Extended Amount” K column on “TrueUp AddProd” tab.
Solved by K. H. in 29 mins
I am using Match and index function to locate interest rate in one tab by looking up the date (mm-yy). but the formula returns N/A when I use mid month date. Please Help!!!
Solved by X. W. in 28 mins