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

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

hello..i need help in left right and mid function

Solved by A. H. in 16 mins

hi i am looking for vba expert . i need to modify an vba excel file.

Solved by X. E. in 21 mins