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

What does the formula =UPPER(MID mean? And what formulas are used in cryptography?

Solved by M. D. in 21 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

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 need a formula built in cell D42 that calculates the cost of all sales people hired that takes into account which month each of them is hired and what type of AE (ENT, MID, SMB) they are

Solved by M. H. in 15 mins