Posted to microsoft.public.excel.misc

LostNFound LostNFound is offline

external usenet poster

Posts: 11

$ 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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find value in array	Brook6	Excel Worksheet Functions	26	January 30th 07 09:40 PM
how do i use & sign without it thinking its a formula	sonnie1964	Excel Worksheet Functions	2	September 12th 06 07:28 PM
Reusing formula	Tony29	Excel Discussion (Misc queries)	7	September 7th 06 03:34 AM
an extra "+" sign in formula	Chris	Excel Discussion (Misc queries)	3	August 2nd 06 08:19 PM
How do I get an automatic equal sign to begin the formula bar?	scarlette belle	New Users to Excel	1	January 5th 06 11:07 PM

All times are GMT +1. The time now is 01:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us