Current location - Information Consultation Platform - Information Service - Ok, in EXCEL, how to enter 7 yuan lowercase numbers in one cell, and then press Enter to automatically display 7 yuan uppercase in another cell?
Ok, in EXCEL, how to enter 7 yuan lowercase numbers in one cell, and then press Enter to automatically display 7 yuan uppercase in another cell?
If the number is in A 1, then B 1 enter:
=IF(ROUND(A 1，2)& lt； 0, "invalid value", IF(ROUND(A 1 2)=0, "zero", if (round (a 1 2).
Simply put, you can enter: = text (a 1, "[dbnum 2]")&; Jacky.