May 3, 2022 · when using the following cell formula =((F5*3.58)+F5) an original value in cell F5 of -1219 incorrectly results in -5583. is there a resolution for this?

Jan 7, 2016 · What I am trying to do is figure out a formula to calculate the percentage of multiple cells. I want to keep track of my employees performance. They are evaluated on a scale from 1-7 and at the …

Oct 18, 2024 · I am trying to get the formula for excel that will provide a birthdate. Exact year plus months! For example: the child is 1 year and 4 months old I would like the answer to be in 1 cell …

Sep 27, 2016 · In addition, had you entered a fraction like 8/10, without the equal sign, it might get converted to a date (assuming your date separator is the "/") -- not a desirable outcome. If you set …

Quiero saber como puedo ejecutar la formula en excel donde pueda, calcular el valor de la edad, a la fecha de ingreso a formulario, la ejecuto pero me da valor de ...

Apr 13, 2024 · Excel排序功能突然不能使用，点击升序或降序排列无反应，重启电脑或新建excel表后仍无法使用，尝试重置excel后仍无法使用。

HolaEmpleo esta formula para contar datos únicos en una columna pero me sale un dialogo de error en la formula.Parece fácil pero...no lo consigo=SUMA(--(FRECUENCIA ...

estoy utilizando la siguiente formula: =SI.ERROR (BUSCARV (B2;'Materials 29012019'!A:K;7;FALSO);BUSCARV (B2;'Services 25022019'!A:K;7;FALSO)) y para la mayoría de …

Nov 5, 2020 · CountIF with pivot table data Hi, I've done some searching and it appears this may not be possible, but I am trying to find a formula that looks at two columns in a pivot table. Both columns are …

Nov 23, 2021 · Most of us in school have a spreadsheet with all our scores to help us optimize our scores in school. this formula for excel can help that, all you need to use it is to designate a cell using …