Get instant live expert help on I need help with excel formula if cell contains
“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
Cell E4 contains formula. I would like to highlight it (Cell E4) if it's overridden manually in Excel 2007.
Solved by V. S. in 30 mins
I am trying to build a formula to do the following: If a cell in column D contains the year 2017, add 52 to the contents of cell C, if column D contains the year 2018, add 104 to cell C. If it contains 2016 display the contents of cell C.
Solved by M. F. in 20 mins
I need a formula that states if Cell C contains 0 then Cell D = 0 but if Cell C contains any number greater than 0 then Cell D will equal the sum of Cells A and B
Solved by V. S. in 12 mins
i need help with a formula.
Example
cell 1a contains "x"
Cell 1b Contains =sum 2a(5):2c(5) Which equals 10
i want cell 2b to be "if cell 1a contains "x" then cell 2c = # inputed-2
so the end value would be 8
how do i word this as a formula?
Solved by B. D. in 23 mins
IF cell R10 contains the formula =$R1+R$2, which is then copied to cell S20, what formula is entered in cell S20?
Solved by B. Y. in 15 mins