Jul 28 2022 12:09 AM
Hi !
I'm working in a spanish Excel and I try to make the average of 2 numbers with a simple formula :
=PROMEDIO(F16;F17)
The numbers "3" you see are in Number format so I don't understand why this simple formula is not working as there is no Zero in the equation
Thanks
Jul 28 2022 12:50 AM
Solution@Eleaamx I suspect that the numbers "3" are in fact texts. Setting the cell format to Numbers does not transform them to numbers. Are these perhaps resulting from an IF function where you entered "3" to be the result? Thus a 3 between quotation marks.
Try this formula:
=PROMEDIO(--(F16);--(F17))
The double hyphen forces Excel to see both threes as numbers. Does that produce a number?
You can also try =ISNUMBER(F16) and the same for F7. If the result is FALSE you are dealing with texts, hence the DIV0 error.
Jul 28 2022 01:05 AM
Jul 28 2022 01:10 AM
@Eleaamx Perhaps better to focus on how the get real numbers in those two cells. Up to you.
Jul 28 2022 03:02 AM
@Eleaamx Try using a comma (",") instead of a semicolon (";") like below
=AVERAGE(F16,F17)
If that doesn't work use the INT function (maybe ENTERO in Spanish) like below,
=AVERAGE(INT(H75),INT(H76))
Jul 28 2022 12:50 AM
Solution@Eleaamx I suspect that the numbers "3" are in fact texts. Setting the cell format to Numbers does not transform them to numbers. Are these perhaps resulting from an IF function where you entered "3" to be the result? Thus a 3 between quotation marks.
Try this formula:
=PROMEDIO(--(F16);--(F17))
The double hyphen forces Excel to see both threes as numbers. Does that produce a number?
You can also try =ISNUMBER(F16) and the same for F7. If the result is FALSE you are dealing with texts, hence the DIV0 error.