switching between formula display and value
 

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.

switching between formula display and value
 

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

Mike

"layvanai" wrote:

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.

switching between formula display and value
 

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

--
HTH

Bob

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

"layvanai" wrote in message
...
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.

switching between formula display and value
 

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

Layvanai

"Mike H" wrote:

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

Mike

"layvanai" wrote:

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.

switching between formula display and value
 

F2 simply put you into edit cell mode

"layvanai" wrote:

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

Layvanai

"Mike H" wrote:

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

Mike

"layvanai" wrote:

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.