How to get the final "result" to show in one cell? Excell 2002

E22 displays as $100.00
D22 displays as $ 50.00
F22 displays as 60
G22 displays as 90

With D22:G22 being the linked cells try this array formula**:

=MAX(D22:G22*{50;100;60;90})

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


"Lisa Ann Kashner" wrote in message
...

Hello,

What you mentioned below is correct:
.....the check boxes are for prices and whichever check box is checked
that's the amount you want in the cell.....

Two of my cells are displaying correctly when checked off - but two are
not
(as I mention below).

Thanks soooo much for you thoughts on this!!
Lisa Ann






--
Thanks in advance! Lisa Ann Kashner


"T. Valko" wrote:

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

Hello,

I put in the array formula in (H22) as you show below, but it gave me the
#VALUE! error now.

I don't understand what you mention about the "key combinations" either. Can
you please explain?

Thanks, Lisa Ann




--
Thanks in advance! Lisa Ann Kashner


"T. Valko" wrote:

E22 displays as $100.00
D22 displays as $ 50.00
F22 displays as 60
G22 displays as 90

With D22:G22 being the linked cells try this array formula**:

=MAX(D22:G22*{50;100;60;90})

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


"Lisa Ann Kashner" wrote in message
...

Hello,

What you mentioned below is correct:
.....the check boxes are for prices and whichever check box is checked
that's the amount you want in the cell.....

Two of my cells are displaying correctly when checked off - but two are
not
(as I mention below).

Thanks soooo much for you thoughts on this!!
Lisa Ann






--
Thanks in advance! Lisa Ann Kashner


"T. Valko" wrote:

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

Hi Lisa Ann

I tried T. Valko solution and it works fine, but the formula needs to be
entered using Ctrl+Shift+Enter...meaning you need to hold down the Ctrl key
and the Shift Key and then hit the ENTER key, if done correctly you'll see
curly brackets { } on each end of the formula in the formula bar.

you can also try this non array formula:

=IF(D22,50,IF(E22,100,IF(F22,60,IF(G22,90,""))))

Regards!
Jean-Guy



Regards!
Jean-Guy

"Lisa Ann" wrote:


Hello,

I put in the array formula in (H22) as you show below, but it gave me the
#VALUE! error now.

I don't understand what you mention about the "key combinations" either. Can
you please explain?

Thanks, Lisa Ann




--
Thanks in advance! Lisa Ann Kashner


"T. Valko" wrote:

E22 displays as $100.00
D22 displays as $ 50.00
F22 displays as 60
G22 displays as 90

With D22:G22 being the linked cells try this array formula**:

=MAX(D22:G22*{50;100;60;90})

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


"Lisa Ann Kashner" wrote in message
...

Hello,

What you mentioned below is correct:
.....the check boxes are for prices and whichever check box is checked
that's the amount you want in the cell.....

Two of my cells are displaying correctly when checked off - but two are
not
(as I mention below).

Thanks soooo much for you thoughts on this!!
Lisa Ann






--
Thanks in advance! Lisa Ann Kashner


"T. Valko" wrote:

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

THANKS A MILLION! It worked just fine! Lisa Ann


"pinmaster" wrote:

Hi Lisa Ann

I tried T. Valko solution and it works fine, but the formula needs to be
entered using Ctrl+Shift+Enter...meaning you need to hold down the Ctrl key
and the Shift Key and then hit the ENTER key, if done correctly you'll see
curly brackets { } on each end of the formula in the formula bar.

you can also try this non array formula:

=IF(D22,50,IF(E22,100,IF(F22,60,IF(G22,90,""))))

Regards!
Jean-Guy



Regards!
Jean-Guy

"Lisa Ann" wrote:


Hello,

I put in the array formula in (H22) as you show below, but it gave me the
#VALUE! error now.

I don't understand what you mention about the "key combinations" either. Can
you please explain?

Thanks, Lisa Ann




--
Thanks in advance! Lisa Ann Kashner


"T. Valko" wrote:

E22 displays as $100.00
D22 displays as $ 50.00
F22 displays as 60
G22 displays as 90

With D22:G22 being the linked cells try this array formula**:

=MAX(D22:G22*{50;100;60;90})

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


"Lisa Ann Kashner" wrote in message
...

Hello,

What you mentioned below is correct:
.....the check boxes are for prices and whichever check box is checked
that's the amount you want in the cell.....

Two of my cells are displaying correctly when checked off - but two are
not
(as I mention below).

Thanks soooo much for you thoughts on this!!
Lisa Ann






--
Thanks in advance! Lisa Ann Kashner


"T. Valko" wrote:

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