switching between formula display and value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

layvanai - 26 Mar 2008 15:24 GMT

The formula written as =IF('Boiler 3'!$M$15<>"",'Boiler 3'!$M$15,"") does not
display the result in the cell even after switching the sheet between formula
and value (ctrl `). This same formula works in other areas of the same
worksheet.

Reply to this Message

Mike H - 26 Mar 2008 15:29 GMT

The cell is probably text
Try selecting the cell
Format|Cell|Number and select general
Tap F2 and then enter

Mike

> The formula written as =IF('Boiler 3'!$M$15<>"",'Boiler 3'!$M$15,"") does not
> display the result in the cell even after switching the sheet between formula
> and value (ctrl `). This same formula works in other areas of the same
> worksheet.

Reply to this Message

layvanai - 26 Mar 2008 15:52 GMT

Thanks Mike it worked, but I don't understand what F2 does.

Layvanai

> The cell is probably text
> Try selecting the cell
[quoted text clipped - 7 lines]
> > and value (ctrl `). This same formula works in other areas of the same
> > worksheet.

Reply to this Message

Mike H - 26 Mar 2008 16:30 GMT

F2 simply put you into edit cell mode

> Thanks Mike it worked, but I don't understand what F2 does.
>
[quoted text clipped - 11 lines]
> > > and value (ctrl `). This same formula works in other areas of the same
> > > worksheet.

Reply to this Message

Bob Phillips - 26 Mar 2008 15:29 GMT

Perhaps the cell is formatted as text. Change the format to General, and
F2-Enter and see if that cures it.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> The formula written as =IF('Boiler 3'!$M$15<>"",'Boiler 3'!$M$15,"") does
> not
> display the result in the cell even after switching the sheet between
> formula
> and value (ctrl `). This same formula works in other areas of the same
> worksheet.

Reply to this Message