Thread: $ SIGN WITH FORMULA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LostNFound LostNFound is offline
external usenet poster
  
Posts: 11
Default $ SIGN WITH FORMULA
I HAVE GOTTEN THE FORMULA TO WORK BUT WOULD LIKE TO ADD THE $ SIGN IN FRONT
OF THE ANSWER SINCE IT REPRESENTS A DOLLAR AMOUNT

=CONCATENATE(IF(E7="A",510.09,""),IF(E7="B",604.96 ,"")
Reply With QuoteReply With Quote