“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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?

Solved by M. S. in 20 mins