Formatting cell with formula

[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

 

[Frank Kabel]

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

 

[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

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

 

[Connie]

Thank you! I should've known that! I don't do these
things often enough!

 

[Connie]

I should've known that! Thank you very much for
responding.