Get instant live expert help on I need help with display cell formulas

“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

Hello! Why doesn't excel display formulas as you type them in a cell anymore? Is there an option to turn it back on?
Solved by A. A. in 23 mins
Need help with countif formulas to display column from one tab to another.
Solved by B. B. in 15 mins
Insert an IF function that compares to see if Yes or No is located in the Rental Car? Column for a city. If the city contains No, display the value in cell F2. If the city contains Yes, display the value in the Rental Car Total (F4). Copy the function from cell E13 and use the Paste Formulas option to copy the function to the range E14:E18 without removing the border in cell E18.
Solved by F. S. in 23 mins
I'm looking to offset from =today(), for example: If cell A13=today(), display cell A20. If cell B13=today(), display cell B20. If cell C13=today(), display cell C20. I want to do this for 365 rows. Is there a simpler way of doing this than a huge nested IF statement?
Solved by K. H. in 12 mins
I would like my result cell to display 1 of 5 values: If my referenced cell value is less than 2 then the result cell should display 2. (values 0 thru 1.99 = 2) but if my referenced cell value is greater than 2 but less than 2.99 then the new cell should display 3 (values 2 thru 2.99 = 3) but if my referenced cell value is greater than 3 but less than 4.99 then the new cell should display 5 (values 3 thru 4.99 = 5) but if my referenced cell value is greater than 5 but less than 7.5 then the new cell should display 7.5 (values 5 thru 7.5 = 7.5)
Solved by S. Q. in 18 mins