AboutPricing

Get instant live expert help on how to use text function in excel

“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.
< Go Back

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

    I need help on how to use indirect function along with sumifs function in excel.
    Solved by Z. W. in 15 mins
    I have a problem regarding to How to Use the MOD Function in Excel
    Solved by S. Y. in 22 mins
    I am using a =SUMIF function, where i need the formula to read the text eg. "Expenses". How do I refer to a cell and for it to pick up the text. In this example, if A2="Expenses", I want to use "A2" in the =SUMIF function but it does not work.
    Solved by K. F. in 12 mins
    I have an excel project to do. It wants me to use the IF function to place the text "yes" in cells I4:I8 if the total is more than a certain number in B15. I don't know how to do this though.
    Solved by G. H. in 12 mins
    If A7 is equal to A20, you want to display the text "OK" in the cell; otherwise, display the text "RETRY" in the cell. (Hint: Use the IF function.)
    Solved by F. A. in 16 mins