That would happen when the linked cells E22 and D22 are FALSE. When those
are FALSE the first part of the formula returns an empty TEXT ("") string
which is concatenated to the result of the second part of the formula. So,
what you get is a result like this: ""60 or ""90. You can't see the "", all
you see is 60 or 90 but it's a TEXT string so the accounting format doesn't
apply.

There's probably a better way to do this if you'd tell use what it is you're
doing. I can sort of guess: the check boxes are for prices or fees and
whichever check box is checked that's the amount you want in the cell? Or ,
you want the highest amount if more than one check box is checked?

--
Biff
Microsoft Excel MVP


"Lisa Ann Kashner" wrote in message
...
Hey guys... one more problem that I came across... are you still there?

I came across a situation that I have 4 different check boxes. Each one
with
a different value. This is my formula:

H22 CELL CONTAINS:
=IF(E22,100,IF(D22,50,"")&IF(F22,60,IF(G22,90,"")) )

The H22 column is set up to display the numbers as: accounting/2 decimal
places/dollar sign.

2 columns are displaying correctly AND 2 columns are not:
E22 displays as $100.00
D22 displays as $ 50.00
BUT...
F22 displays as 60
G22 displays as 90

What am I doing wrong? F22 and G22 are missing the $ and decimal place?

Thank you! Lisa Ann




"Lisa Ann Kashner" wrote:


WONDERFUL! Thank you.... I would just love to have you guys
"smarts"!!!!


--
Thanks in advance! Lisa Ann Kashner


"pinmaster" wrote:

Hi Lisa Ann

Maybe something like this:

=IF(D8=TRUE,60,"")&IF(E8=TRUE,IF(D8=TRUE," - 120",120),"")

HTH
Jean-Guy

"Lisa Ann Kashner" wrote:

Hello, I am soooo confused with this scenario....

I have checkboxes set up.
cell H8 has: 1st checkbox formula is: =IF(D8=TRUE,60,"")
cell I8 has: 2nd checkbox formula is: =IF(E8=TRUE,120,"")

I would like the final result to show up in H8. For example:
If D8 was checked off - I would like the result to show up in H8.
If E8 was checked off - I would like the result to show up in H8 too.

How is this accomplished? Right now I have 2 total columns BUT I
would only
like one

Please help!
Thanks in advance! Lisa Ann