SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

(Solved) - Excel "If" problem.

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

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 1 year 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 1 year 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 1 year ago
Top
 
moreeg
moreeg
Posts: 842

You can try this ...

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

Posted 1 year ago
Top
 
andi009
Posts: 9

Thank you moreeg.

Posted 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.