Please help with Excel formula!

[rsjennifer]

Hi -

I'm TOTALLY not a formula user, so speak slooooooooowly to me!

Here's what I need:

on the SHEET named: "Info"
CELL B12 reads "6pm"
CELL C12 reads "8pm"
on the SHEET named: "Master"
I need a cell to read "6pm, 8pm"
and it needs to come from CELL B12 and CELL C12 on SHEET "Info"
I know how to get them to individually to show up:
=Info!B12
or
=Info!C12
But I can't figure out how to get it to read both cells.
I also figured out how to do it ON the same sheet. If I'm on the "Info" Sheet and I go to a cell and type:
=B12&","&C12
But I can't seem to figure out how to get it to work from a different sheet.

Thanks for any help!
Jennifer in Philly

[DRJ]

Hi - Welcome to the board

You have all the pieces figured out, not just put them together.

=Info!B12 & "," &Info!C12

[rsjennifer]

Thank you - but I tried that! And it's not working. I'm getting that stupid #REF!

I don't understand why.
Jennifer in Philly

[Juan Pablo González]

Try this.

In the sheet where you want the result, select the cell where you want the formula.

Now, type

=

Now, with the mouse, select the 'Info' sheet.

Now click on cell B12.

After that, type

&","&

Now, with the mouse again, repeat the steps that we did for B12, but now for C12.

When you have selected it, press Enter.

You should be done !

[rsjennifer]

Thanks - but now this is showing up IN my cell:

=Info1!B12&","&Info1!C12

Is it me? Am I a TOTAL loss?

Jennifer in Philly

[Juan Pablo González]

That suggest that the sheet is not named 'Info' but rather 'Info1'. Did you get a result in the cell ?

Or is it showing the formula ?

[Brian from Maui]

Originally Posted by rsjennifer

Thanks - but now this is showing up IN my cell:

=Info1!B12&","&Info1!C12

Is it me? Am I a TOTAL loss?

Jennifer in Philly

Click in the cell that displaying that and go to Edit/Repalce, replace = with = somehow the cell is formatted as text

[tactps]

In the tools menu, click on options.

Go to the "View" tab.

Uncheck the box to the left of "formulas" (bottom left)

Hopefully this is the issue

[rsjennifer]

Ah - still not working. I went in, formulas was already unchecked.

And yes, sorry, I did rename Info to Info1, but I did it by directly clicking on the sheet.

When I don't click the sheet, but just try to type it, when I click on the sheet to do it, the formula bar shows me the right result (when you hit the equal sign), but on my actual cell it's showing me the formula.

Arg!


Jennifer in Philly

[tactps]

Try this:

Click on the Format Menu.
Click on "Cells"
In the "Number" tab, ensure that you do not have "text" or a special format selected.

If not:
Try to put the formula in a different cell (new row and column). If it works, cut and paste it into the cell you want.

If it works, post me a Philly Cheesesteak (I've had a 6 year hankering for one!)