| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Cell that Contains If/Then Formula
I have a cell with the following formula:
=IF(A1=0," ",IF(E170,+E17,"0")) I'd like to format the cell with a Currency symbol, but can't seem to figure out how to do so. As long as the above formula is in the cell, the number displays without the currency symbol, even though I've formatted it as currency by going to format cells, number, currency. If I remove the above formula and just type a simple formula like =A1*A2 the number is formatted correctly with the currency symbol. What am I doing wrong? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In a formula, copy the value and formatting of another cell | Excel Worksheet Functions | |||
| cell formula or formatting | Excel Worksheet Functions | |||
| Formatting a formula within a cell | Excel Discussion (Misc queries) | |||
| formatting won't apply to my cell with a formula | Excel Worksheet Functions | |||
| Formatting a cell for color that has a formula also | Excel Discussion (Misc queries) | |||
Threaded Mode
