The How-To Geek Forums Have Migrated to Discourse


How-To Geek Forums / Microsoft Office

(Solved) - Excel "If" problem.

(5 posts)
  • Started 3 years ago by andi009
  • Latest reply from andi009
  • Topic Viewed 883 times

PARTNER SPOTLIGHT

Recommended: Clean Your Mac the Easy Way with CleanMyMac 3

If you want to clean up your Mac the easy way, CleanMyMac is a great tool to get the job done easily, and it will even keep your computer clean automatically.

Unlike the competition, it also includes great tools like a Clean Uninstaller, to get rid of applications and clean up the junk that they leave behind. All with the click of a button.

Download CleanMyMac 3 for Free Today

Posted yesterday 
Top
andi009
Posts: 9

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

Posted 3 years ago
Top
 
scorpion99
Posts: 1033

Hi
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
excel cell

Posted 3 years ago
Top
 
andi009
Posts: 9

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")

Posted 3 years ago
Top
 
moreeg
Posts: 842

You can try this ...

="Client " & TEXT(D1,"#,##0")

Posted 3 years ago
Top
 
andi009
Posts: 9

Thank you moreeg.

Posted 3 years ago
Top
 



Topic Closed

This topic has been closed to new replies.