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