Formatting cell with formula

C

Connie

I have a cell that's formatted to Accounting, 2 decimal
figure, with a dollar sign. It also has a simple IF
function formula in it: =IF(E53=I61,"250",IF
(E53=I62,"500",""))

When the answer is a dollar amount (250 or 500) it's in
the cell as though formatted General or Text, although
cell formatting says it's formatted as Accounting with a
dollar sign and two decimals figures.

How do I make it enter formatted correctly?

Connie
 
F

Frank Kabel

Hi
remove the apostrophes around the returned numbers. So try:
=IF(E53=I61,250,IF(E53=I62,500,""))
 
R

Ron Rosenfeld

I have a cell that's formatted to Accounting, 2 decimal
figure, with a dollar sign. It also has a simple IF
function formula in it: =IF(E53=I61,"250",IF
(E53=I62,"500",""))

When the answer is a dollar amount (250 or 500) it's in
the cell as though formatted General or Text, although
cell formatting says it's formatted as Accounting with a
dollar sign and two decimals figures.

How do I make it enter formatted correctly?

Connie
Click to expand...

The quotation marks that you have around the numbers -- "250" and "500" force
Excel to treat those entries as TEXT and not as numbers to be formatted.

Since you probably want the latter, don't use the quotation marks. Then Excel
will treat the formula results as numbers.


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert number to text as displayed 3
Formatting a Cell Reference with a Formula 6
How do I display text when a cell value is 0 for accounting? 2
conditional formatting a cell that has a formula 6
Formula help 1
How do I create a custom button that combines format settings? 1
Conditional Formatting - Formula to fill cell using >% 2
Complicated SUM IF formula 2

Top