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!”
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