Read just our best, feature-length articles without all the extra stuff.
Answer a Random Geek Trivia Question
Read our first book, the HTG Guide to Windows 8, or check our upcoming books.
Subscribe to our daily email newsletter, chock full of great articles and tips.
Hi. I was trying to add a if function on my excel. That was pretty simple if A1>B1 than show D1.
the problem is that D1=5,000,000 and when it show on the true value it show without comma like 5000000
Can you help me please
right click the cell on which you are having the number 5000000 , and click on Format Cells , then choose number and select "use separators" and decimal to "Zero" as the pic below
Hi scorpion99. thank you for your reply.
Your method work fine if its only a number as true value. I've as true value smth like ("client" &D1& "etc")
You can try this ...
="Client " & TEXT(D1,"#,##0")
Thank you moreeg.
Enter your email address to subscribe to our daily newsletter.