SEARCH

The How-To Geek Forums Have Migrated to Discourse



Join the Discussion at discuss.howtogeek.com

How-To Geek Forums / Microsoft Office

(Solved) - Excel "If" problem.

(5 posts)
  • Started 4 months ago by andi009
  • Latest reply from andi009
  • Topic Viewed 512 times

  • Remove Solved Status
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 4 months ago #
Top
 
scorpion99
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 4 months 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 4 months ago #
Top
 
moreeg
moreeg
Posts: 842

You can try this ...

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

Posted 4 months ago #
Top
 
andi009
Posts: 9

Thank you moreeg.

Posted 4 months ago #
Top