Here are some problems that our users have asked and received explanations on
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
What does the formula =UPPER(MID mean? And what formulas are used in cryptography?
Solved by M. D. in 21 mins
I'm working on a excel sheet that using MID formula to import data in a pivotable, the formula import just a part of the data I don't know why
Solved by O. E. in 27 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
In GI1 char 17,4 I have 2500 why do get 125 using the formula below =IF(MID(GI1,17,4)>2600,125,150)