Here are some problems that our users have asked and received explanations on
I have a cell lets call it $A$1 and when inserting a formula in this cell like =$A$1 or =A1 or =Today() or any formula this cell does not return the reference nor does it return the formula it returns 0 or 00-Jan and does not reflect the formula i inserted in the formula field of this cell. In the attached file look at cell Y1
Solved by B. J. in 30 mins
When D24 consists of 1 and E24 consists of 1, I used this formula to try on if function "=IF(D24=E24, "yes", "no")", but it does not return yes. May I know is there any error with this formula
Solved by C. L. in 24 mins
counting the same numbers in one column
for example when came the last same number how many counts
Solved by T. B. in 16 mins
WHY DOES THE FORMULA =SUM(IF(K3:K5="AA",1,0)) RETURN #VALUE!?
Solved by T. C. in 20 mins
When I exit my document in excel i does not save my graphs? Also, when i click on the cells it does not show the formulas and only shows the numbers?