Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about forumla
I have a cell that needs to change from a % to a $ depending on a validation dropdown list. Once it has been set, I need to be able to tell the difference between the % and the $ in a couple formula's in the same sheet. Thanks -- manesh ------------------------------------------------------------------------ manesh's Profile: http://www.excelforum.com/member.php...o&userid=33268 View this thread: http://www.excelforum.com/showthread...hreadid=530897 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about forumla
manesh,
You could use a formula like: =IF(A2="Test",TEXT(A1,"%0.00"),TEXT(A1,"$0,000.00" )) With a similar test for you further formulas. HTH, Bernie MS Excel MVP "manesh" wrote in message ... I have a cell that needs to change from a % to a $ depending on a validation dropdown list. Once it has been set, I need to be able to tell the difference between the % and the $ in a couple formula's in the same sheet. Thanks -- manesh ------------------------------------------------------------------------ manesh's Profile: http://www.excelforum.com/member.php...o&userid=33268 View this thread: http://www.excelforum.com/showthread...hreadid=530897 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about forumla
So that works, but how do I have 1 cell where you can put in a number, and have that forumla in it. can I have a place to enter text WITh a formula? -- manesh ------------------------------------------------------------------------ manesh's Profile: http://www.excelforum.com/member.php...o&userid=33268 View this thread: http://www.excelforum.com/showthread...hreadid=530897 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is this the proper place to ask my question? | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) | |||
Benefits many people - Question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) |