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

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