Get instant live expert help on if function using text

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

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

insert an if function that first tests whether the value in cell b16 is equal to an empty text string. if it is, return an empty text string; otherwise, apply a lookup function to retrieve the lookup value from the table in the range f5:h8 using the value of cell b16 as the lookup value
Solved by T. B. in 20 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
Using IF Statement with an OR function nested as the logical test how do you work out the following if stephanie has sales less than 600 in october, less than 750 in november., or less than 750 in december. the text No Bonus is shown, and if not, the text bonus is shown
Solved by I. D. in 11 mins
Understand a if plus date function - if a cell has text then return a date
Solved by C. Q. in 28 mins
How do I create a function to replicate text in a cell if a preceding​ cell has text that is BOLD?
Solved by O. H. in 13 mins